Networks

Ask something
Question Locked

MySQL User Permissions Error When Attempting Remote Connection

0 helpful
2 replies

by archivist007

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

Thanks.

2 replies

by jaqui

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 http://mysql.com/

This discussion is closed to new replies.