Connection problem
Date: October 15, 2009 12:52AM
Hi everyone,
I have 2 servers: 1 for application (call A), 1 for database (B).
On B, I open port 3306, create mysql database account, grant access. In short, I managed to connect A from B using "mysql -h <IP of A> -u username -p"
However, when I use mysql_connect in pHP, I cannot connect. The error is "Can't connect to MySQL server on xxx.xxx.xxx.xxx (13)".
I tried every solutions that I can found on google, including
- add [mysql] socket = /var/lib/mysql/mysql.sock to my.cnf file
- check --skip-network = false
- comment bind-address = 127.0.0.1
Still, no solution works for me.
I really appreciate if anyone can help me.
Thank you for reading this post :).