?
Solved

MySQL 1130 remote server error

Posted on 2011-02-28
1
Medium Priority
?
459 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 11

Accepted Solution

by:
Murfur earned 500 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

WordPress Tutorial 3: Plugins, Themes, and Widgets

The three most common changes you will make to your website involve the look (themes), the functionality (plugins), and modular elements (widgets).

In this article we will briefly define each again, and give you directions on how to install them.

Question has a verified solution.

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

Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
This article discusses how to implement server side field validation and display customized error messages to the client.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

777 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