Navicat Access denied for ‘password‘. Authentication that can continue: publ1045 - Access denied for

云墨cloudMel

于 2021-07-20 22:18:59 发布

阅读量5k

点赞数 1

分类专栏： MySQl

本文链接：https://blog.youkuaiyun.com/weixin_42481234/article/details/118945984

版权

MySQl 专栏收录该内容

5 篇文章

订阅专栏

Navicat Access denied for 'password'. Authentication that can continue: publ1045 - Access denied for user 'root'@'139-218-163-195.sta.dodo.net.au' (using password: YES)

用户名和密码正确，但是却没有在其他ip地址上访问的权限。需要登录MySQL然后修改ip访问权限。

`
GRANT ALL PRIVILEGES ON *.* TO '登录用户名（如：root）'@'%' IDENTIFIED BY '登录密码（如：123456）' WITH GRANT OPTION;
`
`
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
`
//刷新
`FLUSH PRIVILEGES;`