I run a wordpress installation with MySQL DB on webfaction. I cloned the WP and DB to a local instance (using a plugin called duplicator, works fine locally). Now I want to connect the local instance of wordpress to the remote production DB via these steps:
The tunnel and credentials must work because connecting with the mysql client works:
Unfortunately calling Wordpress fails:
I used this script to test the database connection from PHP, which produces a slighty more elaborate error:
Also when I try to connect with a local phpmyadmin (changed credentials):
I googled for while and suspect this might be related to the different PHP versions or Apache configuration. Here are the phpinfos form the remote server and the local I would be very grateful for pointers. asked 05 Dec '12, 18:43 ampelmann |
Everything you're doing looks right to me. Perhaps the MySQL-PHP adapter version in your local PHP is incompatible with the version of MySQL on our server?
I'm not familiar with PHP under windows, so it's also possible that there's some idiosyncrasy there; can you test this under a linux VM to see if it's repeatable under another OS?