phpmyadmin连接mysql时登录不了,提示mysqli_real_connect()
现象
phpmyadmin连接mysql时登录不了,提示mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]并且登录不了mysql,用命令行可以登录.
解决方案
- 命令行登录mysql;
- mysql>use mysql;
- mysql>ALTER USER root IDENTIFIED WITH mysql_native_password BY '你的密码';
- mysql>FLUSH PRIVILEGES;