Gregory Machin wrote:
i'm a beginner at mysql server - and i have the following problem i can connect to my database which is residing on my mail server from my web server. the my.cnf looks correct and has the port 3306 set , but can't telnet in eather .
if i use mysql --host=x.x.x.x --port=x.x.x.x --usr=root it gives me the following error: Can't connect to MySQL server on x.x.x.x (111) many thanks greg
The default debian configuration for mysql has the "skip-networking" option set in my.cnf. That is probably causing your problems. Simply comment that line in my.cnf and restart mysql.
Maarten Vink