错误提示:message from server: "Access denied for user 'root'@'localhost' (using password: YES)"
解决方法:
权限问题
法一:mysql>grant all on *.* to root@'%' identified by '1234567';
法二:Mysql>grant all privileges on *.* to’backup’@’192.168.188.2’ identified by ‘1111’;
'给使用192.168.188.2连接的backup用户以所有权限.
Mysql>flush privileges;
'更新权限.
阅读(651) | 评论(0) | 转发(0) |