
Navicat Access denied for ‘password‘. Authentication that can continue: publ1045
Navicat Access denied for 'password'. Authentication that can continue: publ1045 - Access denied for user 'root'@'139-218-163-195.sta.dodo.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;`
👁️ 阅读量:0
© 版权声明:本文《Navicat Access denied for ‘password‘. Authentication that can continue: publ1045》内容均为本站精心整理或网友自愿分享,如需转载请注明原文出处:https://www.zastudy.cn/wen/1686964536a410364.html。