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..