MySQL User Permissions Error When Attempting Remote Connection

By archivist007 ·
I'm having problems with a web-server not being able to log in remotely to a database server. Both servers are running Ubuntu 8.04.2. The web-server is running Apache 2.2.8 and PHP5 and is located in our network's DMZ, and the database server is running MySQL 5.0.51 in the trusted internal network.

I've opened the bind address on MySQL to allow for external connections. I can log in locally to MySQL on the database server using the database user.

I have also checked the user permissions. I tried it with both 'user'@'webserver' and 'user'@'%', and neither option resolves the issue. In MySQL CLI, the privileges table shows that the user has full permissions, but I still can't make the remote connection. The problem still persists even when I select "any hosts".

Does anyone have any ideas as to what the problem might be?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by Jaqui In reply to MySQL User Permissions E ...

newer versions of MySQL actually are configured by default to reject remote connections.
You will need to edit the MySQL configuration file and allow remote connections.

I would recommend going through the documentation for the specific version of MySQL on

Related Discussions

Related Forums