Page 1 of 1

Client does not support authentication protocol - Mysql

PostPosted: 02. January 2005 19:35
by mobious

I am getting a error attempting to access the Mysql server from a remote website.

Could not connect to mysql: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I allowed mysql to be accessed from the network and set my user account to be allowed from any domain and the webserver I am trying to access it from.

Also, I just updated Xampp for version 1.4.11..

Thanks for the help..

PostPosted: 04. January 2005 15:10
by mobious
No one has an idea about this problem?? I saw the error in the German support forums but could get a good translation for it..

PostPosted: 04. January 2005 20:33
by Oswald
Dear mobious!

Simply edit the file /opt/lampp/etc/my.cnf and insert old-passwords after the line containing [mysqld]. It should look like:

# The MySQL server
port = 3306

Restart MySQL or XAMPP and now you should be able to connect with an old client.


PostPosted: 05. January 2005 04:50
by mobious
Thanks for the effort..
But it still didnt work..
Here is part of my my.cnf file

# commented out by lampp security
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
# log-bin deactivated by default since XAMPP 1.4.11
server-id = 1

PostPosted: 05. January 2005 10:18
by Oswald
Dear mobious!

That's bad. First a question: Which version of XAMPP do you used as you were setting passwords for MySQL?

The problem is you are using the new password hash format of MySQL and your client is to old to support this new format.

A solution is described here:

But in my opinion you shoud try to upgrade your client. If possible.

Greetings and good luck

PostPosted: 05. January 2005 14:24
by mobious
I used the previous version of 1.4.11 to set my passwords.

I installed XAMPP for windows on my windows 2k server.. Where I am trying to access the data from. I can access the database locally but can not connect to the remote db on my linux server..

I will try that link you sent and see if that works.

BTW.. When I SSH to the box I cant even logon to the mysql server at the command line..
Do you think if I back up the website.. Uninstall Xampp remove all the old files and folders then install the new version again and set up the DB again.. Do you think this would fix my problem? I noticed when i installed the pervious version I couldnt even login locally as root. It kept saying root@localhost not allowed..

PostPosted: 06. January 2005 17:14
by mobious
Ok I found my answer.. If anyone ever needs to access the mysql DB from a remote application or website and get this error go here..

it fixed me right up!

Thanks for the help!