Need help with enabling remote access to mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Rippie
Forum Commoner
Posts: 76
Joined: Sun Jan 10, 2010 11:32 am
Location: Nottingham

Need help with enabling remote access to mysql

Post by Rippie »

Hi all,

I have looked through guides online and i cant figure out how i enable remote access to a mysql server running on a CentOS system.

I have followed this guide: http://www.cyberciti.biz/tips/how-do-i- ... erver.html

I am sitting on a Windows 7 domain workstation and our internal only server is running on a CentOS system as previous stated. A colleaugue of mine has set up the CentOS box but does not know much to MYSQL.

When connecting to the mysql server from the php page i have running on my own local apache webserver it just give a blank screen. PHP is working on it as my phpinfo page shows ok and mysql is enabled.

If i use EMS SQL Manager to connect to the remote mysql server i get "Can't obtain database list from the server." and "Access denied for user 'root@003545dt.domain.local' (using password: YES)"

I think this is related to access permission, but not sure how to fix it.

what i want to achive is to have apache and php running on my domain workstation but use the mysql server on the company webserver.

Hope someone can help.

Rippie
Post Reply