Link to home
Start Free TrialLog in
Avatar of Daniel Wilson
Daniel WilsonFlag for United States of America

asked on

PHP mysql_connect to remote server

I am moving an application to a different set of servers with an upgraded stack.  I'm going from one Ubuntu server with standard MySql to a pair of CentOS servers.  The DB server runs MariaDB.

I can now make the remote connection using mysql -h 10.1.1.1 -u my_user -p my_database, indicating that the firewall is not the problem and neither are the permissions.

However, mysql_connect fails.  I've temporarily hard-coded the parameters so I'm sure I'm attempting the right connection.

What other errors should I look for?

Thanks!
SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Daniel Wilson

ASKER

Can't connect to MySQL server on '10.x.y.z' (13)

Open in new window


Oops, yeah, I've upgraded to php 5.6.6.

So ... the upgrade to the newer library is forced.

Thanks!