Start a conversation

Connection problem with MySQL

This problem occurs when using an old user and password, incapable with the actual version of the cryptography used to authenticate the user’s login, because of that, the PHP cannot make a connection.

When this user try’s to login it will be blocked with a message:

"Client does not support authentication protocol requested by server"

To fix this problem you should do the following procedure:

  • Access your database through command line and run this example:
  • SET PASSWORD FOR 'root ‘@’localhost' = OLD_PASSWORD ('PASSWORD');
  • In case the problem was not solved with the password change, run this line:
  • UPDATE mysql.user SET Password = OLD_PASSWORD('PASSWORD') WHERE User = 'USER ';
  • FLUSH PRIVILEGES;


Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Amanda Santos (Migrated deleted Agent)

  2. Posted
  3. Updated

Comments