Solved

MySQL 1130 remote server error

Posted on 2011-02-28
1
437 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
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
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.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now