laravel 报错:
Illuminate\Database\QueryException : SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
用户的 Authentication type
默认为 caching_sha2_password
,导致数据库连接错误,
这个方法不能解决问题:
https://laravel-china.org/articles/10736/some-craters-in-mysql-8011
最后解决:
修改 my.cnf
default_authentication_plugin=mysql_native_password
补充:三种连接方式
http://www.runoob.com/php/php-mysql-connect.html
1) mysqli 面向过程
$servername = "127.0.0.1"; #这里改了 localhost 无法连接
$username = "test";
$password = "