Laravel 5.1with PHP 5.6 and MySQL 8.0
MySQL server 8.0 enabled with new user authentication mechanism. This mechanism may not supported by Laravel 5.1.x with PHP 5.x versions. It also throws exception from Laravel library for database connection. Error example: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client The server requested authentication method unknown to the client [caching_sha2_password] To resolve errors, run the MySQL service with support of old authentication mechanism. Open mysql my.cnf (Path : 'C:\ProgramData\MySQL\MySQL Server 8.0' in windows 10 Pro) using any text editor. Update the value of 'default_authentication_plugin' to 'mysql_native_password'. Restart MySQL service to make the updated configuration in effect. Testing Environment Used. Windows 10 Pro MySql 8. PHP 5.6.0 Laravel 5.1