Apache Friends Support Forum

Hello,

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..

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..

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
[mysqld]
old-passwords
port = 3306
...

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

Greetings
Oswald

Thanks for the effort..
But it still didnt work..
Here is part of my my.cnf file

[mysqld]
# commented out by lampp security
old-passwords
port = 3306
socket = /opt/lampp/var/mysql/mysql.sock
skip-locking
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
#log-bin
server-id = 1

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: http://dev.mysql.com/doc/mysql/en/Old_client.html

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

Greetings and good luck
Oswald

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..

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..

http://dev.mysql.com/doc/mysql/en/Old_client.html

it fixed me right up!

Thanks for the help!