如何解决php mysqli_connect: authentication method unknown to the client [caching_sha2_password]的问题？

如何解决php mysqli_connect: authentication method unknown to the client [caching_sha2_password]的问题？

这个是在php5中连接mysql的问题。

在my.ini中添加：default_authentication_plugin=mysql_native_password

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
#default_authentication_plugin=caching_sha2_password
default_authentication_plugin=mysql_native_password
character-set-server = utf8
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION 

然后用下列命令修改密码：

ALTER USER 'mysqlUsername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysqlUsernamePassword';

或者新建用户：

 CREATE USER 'jeffrey'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';