If you have a mysql authentication issues related to the error below you can take the following steps to resolve this problem.
Error: Client does not support authentication protocol requested by server; consider upgrading MySql client. old_password related errors.
Solution:
This server may be running mysql 5 and has created the user with an older version of phpmyadmin not compatible with authentication protocol in mysql5.
1 . Update the user table for the already created user with old_password method using the command below.
update mysql.user set password=old_password('users_passwd') where User='user_name';
2. Additional steps may be required
- comment out old_passwords from my.cnf
- restart mysql, update the root user password
- enable old_passwords back
- restart mysql
