Connect to your MySQL database from a remote connection

[youds]

Hi

I have followed the instructions on http://help.directadmin.com/item.php?id=308 however I still can't access the database remotely. I have entered % for the host but no joy. My firewall allows 3306 port connections. (I've tried it with firewall disabled too)

Any help would be appreciated.

 

[Richard G]

Does the firewall allow both incoming and outgoing connections on port 3306?
Have you restarted the mysql service?
What is the exact error notice you see when you try to connect?

 

[youds]

Hi Richard

The firewall has been configured to allow 3306 ports and I've checked the connection with the firewall disabled but still no joy.
I have restarted the mysql process.
The error I'm getting in php is

Warning: mysql_connect(): Can't connect to MySQL server on 'youds.com'

and the error from mysql command in bash is

ERROR 2003 (HY000): Can't connect to MySQL server on 'youds.com' (110)

 

[Richard G]

Check /etc/my.cnf for this line:

bind-address = 127.0.0.1

change this (or add it) to your server ip:

bind-address = your.server.ip.here

I hope that fixes it. Be sure to restart mysql after changing this.