MySQL 8.0+ error: The server requested authentication method unknown to the client

David Carr

1 min read - 5th Dec, 2019

Upgraded MySQL to v8 and starting getting connection errors due to how MySQL 8 defaults to auth_socket connections. Applications that use passwords will fail and generate the error:

PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client

The solution is to change the default authentication method to mysql_native_password.

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

Replace password with your password, if you don't use a password then enter it as ''

Thanks to this stackoverflow post

0 comments
Add a comment

Copyright © 2024 DC Blog - All rights reserved.