Solved

MySQL 1130 remote server error

Posted on 2011-02-28
1
448 Views
Last Modified: 2012-05-11
Hi all,

I'm installing a MediaWiki.

The Wiki setup can't connect to the DB (on a remote system. The error is:

Attempting to connect to database server as root...failed with error [1130] Host 'appserver' is not allowed to connect to this MySQL server.


I have run the oft-quoted command:
GRANT ALL PRIVILEGES ON *.* TO root@'mysqlhost' IDENTIFIED BY 'password';

But to no effect. Can anyone advise?
0
Comment
Question by:bheroniphr
1 Comment
 
LVL 11

Accepted Solution

by:
Murfur earned 125 total points
ID: 35000534
You need to grant access to the requesting source host

GRANT ALL PRIVILEGES ON *.* TO root@'appserver' IDENTIFIED BY 'password';

obviously substituting 'appserver' with appserver's IP address... :)
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question