Need help with enabling remote access to mysql
Posted: Wed Jun 16, 2010 5:34 am
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
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