Error connecting to host mysql

Scriptcase 8 Discussion
#1

Hello,
I’ve been developing on my home computer (mysql version 5.6.27) with no problem.

I’m having an issue connected to my ISP host mysql server. This is a shared host (at least right now), not a VPS.
Connection attempt failed: SQLSTATE[HY000] [2054]
The server requested authentication method unknown to the client PDO::__construct():
The server requested authentication method unknown to the client [mysql_old_password]

I’ve been developing on my home computer (mysql version 5.6.27) with no problem.
My ISP server is mysql version 5.5.38

I’m assuming that my ISP is using the old mysql password hash, even though they are on 5.5.38? Does that sound right?
Is there any suggested changes I can make on my client to get connected?

I talked to tier 1 support at my ISP and they were no help and am waiting for a call back from tier 2.

#2

It says that PDO is not supported at your host. So you need to use one of the other connection options.

#3

Thank you, Albert. I tried other connection types and could not get connected. I was able to get connected through MySQL Workbench by checking “use old authentication protocol”. But the speed was terrible. 2 mintues just to fetch the table names. I was using an “off brand” ISP and switched to Godaddy, now all is good.