WebFaction
Community site: login faq

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:

  1. Setup Tunnel for port 3306 on localhost as described here
  2. Change wp-config.php to match remote credentials link

The tunnel and credentials must work because connecting with the mysql client works:

PS C:\xampp\mysql\bin> .\mysql.exe -u b2blogin_veodin_ -D b2blogin_veodin_ -p

Unfortunately calling Wordpress fails:

Error establishing a database connection

I used this script to test the database connection from PHP, which produces a slighty more elaborate error:

Could not connect to the MySQL server: The server requested authentication method umknown to the client

Also when I try to connect with a local phpmyadmin (changed credentials):

'#2054 - The server requested authentication method umknown to the client

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
3522024
accept rate: 0%

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?

(06 Dec '12, 00:20) ryans ♦♦
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×262
×168

question asked: 05 Dec '12, 18:43

question was seen: 5,227 times

last updated: 06 Dec '12, 00:20

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2019 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM