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
Subscribe to my newsletter for the latest updates on my books and digital products.
Find posts, tutorials, and resources quickly.
Subscribe to my newsletter for the latest updates on my books and digital products.
