MySQL 8.0 Authentication Error: How to Fix 'Client does not support authentication protocol requested by server'?

"MySQL 8.0: Authentication Error Resolved - Client Incompatibility"

Users encountering the "Client does not support authentication protocol requested by server" error when attempting to connect to MySQL 8.0 frequently experience this issue. This occurs when the MySQL client version is incompatible with the authentication protocol used by the MySQL server.

Understanding the Problem

MySQL 8.0 introduced a new authentication method called SCRAM-SHA-256. If the MySQL client lacks support for this method, it will fail to establish a connection, resulting in the error mentioned above.

Solution:

1. Check Client Compatibility:

Confirm whether the MySQL client version is compatible with MySQL 8.0. If not, upgrade the client to the latest version.

2. Reset User Authentication:

Using MySQL Workbench or another tool, execute the following queries:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;

Ensure to replace 'root' and 'password' with your actual username and password, respectively.

3. Retry Connection:

Attempt to establish a connection to the MySQL server again using the node.js code provided. If the SCRAM-SHA-256 authentication method is now supported by the client, the connection will be established successfully.

4. Alternative fix:

If the above steps do not resolve the issue, remove the @'localhost' part from the user specification in the ALTER USER query, i.e.:

ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'password';

5. Verify Active Connection:

Check the MySQL console or run the following query to verify that the connection is active:

SELECT USER();

If it returns your username, the connection is established successfully.

The above is the detailed content of MySQL 8.0 Authentication Error: How to Fix 'Client does not support authentication protocol requested by server'?. For more information, please follow other related articles on the PHP Chinese website!