MySQL Error# 1251Client does not support authentication protocol requested by server

Report · Oct 09, 2006

I have a fasthosts server with Apache 2.0.46 (Red Hat Linux Enterprise 3) and MySql 4.1.15 installed with PHP 4.3.2. When trying to set up DW to access my database I receive the error :

"MySQL Error# 1251 Client does not support authentication protocol requested by server; consider upgrading MySql client"

This error only happens when I create a NEW MySQL user to connect to a new database. I have never received this error before (I haven't upgraded the server or DW).

I know that there is a workaround here: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=c45f8a29 but I don't understand why it does not affect existing databases on the same server.

I do not have the same problem connecting to existing databases, this only happens once I have created a new database on the Fasthosts Matrix control panel. I can connect to the existing databases on the same server without any problems.

Surely I should be able to connect to the database immediately after creating a new database & user?

Why would this problem appear all of a sudden??

Report · Oct 09, 2006

dalydesign wrote:
> I have a fasthosts server with Apache 2.0.46 (Red Hat Linux Enterprise 3) and
> MySql 4.1.15 installed with PHP 4.3.2. When trying to set up DW to access my
> database I receive the error :
>
> "MySQL Error# 1251 Client does not support authentication protocol requested
> by server; consider upgrading MySql client"

This is a question that you should be addressing to Fasthosts support,
not here. The situation is caused by the combination of PHP 4.3.2 and
MySQL 4.1.15. PHP 4.3 doesn't support the new authentication protocol in
MySQL 4.1 and higher.

> I can connect to the existing databases on the same server without any
> problems.

Existing passwords were probably created using the old protocol and were
not changed when MySQL 4.1 was installed.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Oct 10, 2006

Thanks for the info David. You've confirmed what I thought. I just needed to rule out any issues with DW.

I have already contacted Fasthosts and are awaiting their reply.

It is a strange problem as PHP 4.3.2 and MySQL 4.1.15 was already installed on the server as standard for the last 6 months. They have not been upgraded/updated at any time since I had the server. Existing passwords have been fine with this setup... until yesterday - then it decides that it won't support the authentication protocol.

I'm convinced fasthosts have updated their Matrix control panel software and it's now saving the password using the new authentication protocol whereas previously it was saving passwords using the old protocol.

I'll await to see what Fasthosts say....

Report · Oct 16, 2006

Fasthosts were hopeless, they wanted to charge £120 + vat per hour to investigate it. They kept stating that I'd upgraded MySQL (but I hadn't - it was the version they had installed) they also stated that dreamweaver was at fault. Their tech support staff are hopeless, it was as though they were reading out of a beginner's manual.

I have done my own research and fixed the password problem myself by inserting the following command:

#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

Insert it into the etc/my.cnf file

It needs to be inserted directly under this command: [mysqld]