版本:数据库:mysql8.0.27;php版本:5.4.3;ubantu 20.0.7
本来我是想开个discuz服务器,服务器也有了,后面在安装数据库的过程时遇到了错误
提示是客户端未知的服务器请求的身份验证方法
我登入mysql后将所有用户密码验证方式都改成了mysql_native_password
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| % | root | mysql_native_password |
| 127.0.0.1 | Dty903mysql | mysql_native_password |
| localhost | Dty903mysql | mysql_native_password |
| localhost | debian-sys-maint | mysql_native_password |
| localhost | hehe | mysql_native_password |
| localhost | mysql.infoschema | mysql_native_password |
| localhost | mysql.session | mysql_native_password |
| localhost | mysql.sys | mysql_native_password |
+-----------+------------------+-----------------------+
8 rows in set (0.00 sec)
奇怪的是他仍然提示:
Warning: mysqli_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
不知道这是怎么回事,权限已经将/var/lib/mysql/ 777全给了
请各位大佬解答一下,谢谢