目录
使用navicat可视化工具远程连接MySQL服务时,出现报错:
回想之前刷新MySQL外部登录权限时,设置的密码与登录密码不一致导致报错。
解决方案:
本地登进MySQL服务, 再次刷新MySQL外部登录权限。
mysql> grant all on *.*to 'root'@'%'identified by '外部登录密码';
mysql> flush privileges; 即刻刷新权限
成功连接,完美解决。
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
字数规定。
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)
1045 - Access denied for user ‘root‘ @‘***.***.***.*‘ (using password: YES)