报错详情:
登录数据库报错无法登录Mysql 服务器
mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
报错截图:
![图片[1]-mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)解决方法-易站站长网](https://www.yizhanzzw.com/wp-content/uploads/2022/04/1650599522-5fe90bf99c6a5cc.jpg)
报错原因:
root的值没有localhost
解决方案:
1.如果phpMyAdmin可以使用root登录,那么就phpMyAdmin登录(我这里是phpMyAdmin无法登录)
如果phpMyAdmin无法登录那么使用mysql远程链接工具,远程链接登录。
2.登录成功以后修改mysql表中数据库user的root值为localhost(如图所示修改)
![图片[2]-mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)解决方法-易站站长网](https://www.yizhanzzw.com/wp-content/uploads/2022/04/1650600883-585359640310443.jpg)
3.修改以后记得一定要重启mysql。
![图片[3]-mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)解决方法-易站站长网](https://www.yizhanzzw.com/wp-content/uploads/2022/04/1650600947-e6e0f7e199c3a97.jpg)
4.重新登录尝试,不会报错,登录成功!
![图片[4]-mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)解决方法-易站站长网](https://www.yizhanzzw.com/wp-content/uploads/2022/04/1650600969-b067368b4d9d080.jpg)
5.问题解决!
THE END























【年费SVIP会员】99元全站资源免费下载
本站已开通会员技术交流QQ群,仅限SVIP永久会员加入,群号:831041601
- 最新
- 最热
只看作者