1 Topic by randunel (edited by randunel 2004-12-18 11:15)

  • Registered: 2004-12-18
  • Posts: 3

Topic: Error: Unable to connect to MySQL server. Client does not support auth

Error: Unable to connect to MySQL server. Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Latest MySQL installed, PHP. Same error with 3 different web servers, when installing the forum. Any sollutions to this problem? Or is the forum too old to work with new versions of MySQL?

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Error: Unable to connect to MySQL server. Client does not support auth

With the introduction of MySQL 4.1, the authentication process was somewhat changed. What the error means is that your PHP environment doesn't support authentication with your MySQL server. Could you give us some more info on your setup? Operating system, PHP version, MySQL version, what you selected in the install etc.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2004-12-18
  • Posts: 3

Re: Error: Unable to connect to MySQL server. Client does not support auth

Well, I have PHP 4.3.9 but i see that it has been updated, i'll download the newer version and install it. I have MySQL 4.1.7, but it has also been updated, i'll update it too. PunBB 1.1.5; OS: Win XP (updated smile)
I wanted to test the site on my computer first for a week or so (to see any bugs), beore moving it on a Slackware server.

I selected:
[*] Database type: MySQL
[*] Database name username and password: my databases' name, a username with "SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP" rights and its password smile
[*] Table prefix: pun_
[*] Admin username, pass, email: my own
[*] Base URL: http://myhost.com/forum tongue

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Error: Unable to connect to MySQL server. Client does not support auth

I'm not sure how this works in Windows, but you need to make sure that the MySQL dll your using is based on the new MySQL client library.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • Registered: 2004-12-18
  • Posts: 3

Re: Error: Unable to connect to MySQL server. Client does not support auth

the MySQL dll and all related to MySQL is updated 100% tongue My machine is the server, the forum is the client which is trying to access the database (server)! So any updates for the client are actually updates for the forum... (considering that I have the latest PHP).

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Error: Unable to connect to MySQL server. Client does not support auth

I'm sure you have the latest PHP installed, but is your PHP using the latest MySQL library dll? THAT is the question.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website