Navicat连接服务器弹出1045 access denied for user ‘root‘@‘IP地址‘(using password :yes)_navicat 连接测试access denied for user 'root'@'ip' (us-CSDN博客

网友收藏2024-01-24 23:37

链接地址：https://blog.csdn.net/cuilei210/article/details/118254072
链接标题：Navicat连接服务器弹出1045 access denied for user ‘root‘@‘IP地址‘(using password :yes)_navicat 连接测试access denied for user 'root'@'ip' (us-CSDN博客
所属网站：blog.csdn.net
被收藏次数：7476

文章浏览阅读826次。这是因为自己本地开发环境电脑的IP地址，并没有赋予访问服务器端mysql数据库的权限。解决办法：1.在mysq中运行下面命令：use mysql;create user 'root'@'IP地址' identified by '密码';update user set Password ="密码" where Host="IP地址" and User="root";grant all privileges on *.* to root@'IP地址';2.查看数据库mysql中user表中Hos_navicat 连接测试access denied for user 'root'@'ip' (using password:)

本文地址：https://tebull.com/detail/568369.html

标签：navicat 连接测试access denied for user 'root'@'ip' (using password:)