Apache on Debian server to connect to extern mysql

Question

I have servers :

I installed apache on my debian server. I want to access my SQL server through PDO. But an error occurs :

SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'my_sql_server_ip' (110)'

However, I can access my SQL server from local apache server (MAMP). So I think the problem is client side.

Any suggestion ?

possible duplicate of [ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)](http://stackoverflow.com/questions/1673530/error-2003-hy000-cant-connect-to-mysql-server-on-127-0-0-1-111) — Kevin Brown-Silva, Jan 19 '15 at 16:55

score 0 · Answer 1 · answered Jan 19 '15 at 17:39

0

On MAMP , click File Menu > Edit Template > MySQL my.cnf

and change bind-address = 127.0.0.1 by bind-address = 0.0.0.0

(don't edit directly /Applications/MAMP/tmp/mysql/my.cnf because MAMP will overwrite the file on restart)

answered Jan 19 '15 at 17:39

Hi, my SQL server is not local. It's an OVH private database. – ThBM Jan 20 '15 at 18:39
So you have a private MySQL database and a VPS and you know their IP addresses ? and how did you configured MAMP when you said the connection worked ? – Gerard Rozsavolgyi Jan 20 '15 at 21:52
I just put my sql sever's ip instead of localhost when I want to connect with PDO and it works – ThBM Jan 22 '15 at 06:47

1 Answers1