Why Does My PHP 7.0 Application Get a 'MySQL Connection Error: Unknown Authentication Method'?

MySQL Connection Error: Unknown Authentication Method

When attempting to establish a connection to a MySQL database from PHP 7.0, users may encounter the error message: "The server requested authentication method unknown to the client."

This error typically arises from a mismatch between the authentication plugin configured on the MySQL server and the authentication method expected by the PHP application. By default, MySQL 8 uses the "auth_socket" plugin, which relies on a secure socket connection for authentication. However, many PHP applications anticipate a traditional password-based authentication mechanism.

Solution:

To resolve this issue, you can change the MySQL server's authentication plugin to one compatible with your application's authentication method. Following are the steps to modify the authentication plugin:

1. Log in as root to MySQL: Use the "mysql" command to initiate the root user connection.
2. Execute the following SQL command: This command will alter the authentication plugin for the root user to "mysql_native_password," which supports password-based authentication.

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

3. Replace "password" with your root password: If your application utilizes a different user, replace "root" with the appropriate user in the command above.
4. Restart the MySQL service: To ensure the changes take effect, restart the MySQL service.

Once these steps are completed, your PHP application should be able to connect to the MySQL database without encountering the "authentication method unknown to the client" error.

The above is the detailed content of Why Does My PHP 7.0 Application Get a 'MySQL Connection Error: Unknown Authentication Method'?. For more information, please follow other related articles on the PHP Chinese website!