13) I have created the MySQL database user properly with all rights and setup Conf.php correctly, when I login I get an error saying; "Client does not support authentication protocol requested by server; consider upgrading MySQL client"

From OrangeHRM

Jump to: navigation, search

You are probably using PHP4 with a MySQL client older than 4.1 which does not support the password hash algorithm used by post-MySQL 4.1 databases. The work around for the problem would be to use the following commands on MySQL prompt; 

           SET PASSWORD FOR '<username>'@'%' = OLD_PASSWORD('<password>');
                                               
                                      OR

           SET PASSWORD FOR '<username>'@'localhost' = OLD_PASSWORD('<password>');
Retrieved from "http://www.orangehrm.com/wiki/index.php/13%29_I_have_created_the_MySQL_database_user_properly_with_all_rights_and_setup_Conf.php_correctly%2C_when_I_login_I_get_an_error_saying%3B_%22Client_does_not_support_authentication_protocol_requested_by_server%3B_consider_upgrading_MySQL_client%22"
Personal tools