Page 1 of 1

Need help with enabling remote access to mysql

Posted: Wed Jun 16, 2010 5:34 am
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