Currently seeking new career opportunities in web development, particularly with Laravel, Hire Me

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

David Carr

Development

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

Laravel Modules Your Logo Your Logo Your Logo

Become a sponsor

Help support the blog so that I can continue creating new content!

Sponsor

My Latest Book

Modular Laravel Book - Laravel: The Modular way

Learn how to build modular applications with Laravel Find out more

Subscribe to my newsletter

Subscribe and get my books and product announcements.

Learn Laravel with Laracasts

Faster Laravel Hosting

© 2006 - 2024 DC Blog. All code MIT license. All rights reserved.