Remote Connection to mysql server
 

Anyone??? When I try to connect to mysql (redhat flavor) from my windows using mysqlcc or a linux box with mysql -h *.*.*.* I get Error 1045:Access Denied for user test@*.*.*.* (Using Password: Yes) Now I did use "Grant ALL ON test.* to test@'%' IDENTIFIED....." in the local mysql. Is there a setting in the my.conf I must change to allow remote access. I also ensured that the hosts.allow has the mysql port open to both machines.Many thanks..

run this

netstat -lnp | grep 3306


see if it's running
[root@zeus root]# netstat -lnp | grep 3306

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 18839/

18839 is the PID

check to see that the PID is mysqld

ps p 18839

PID TTY STAT TIME COMMAND
18839 pts/4 S 0:00 [mysqld]




If it's running then you can check for a firewall blocking the connection