美文网首页
【故障集合】MySQL错误集合(持续补充中)

【故障集合】MySQL错误集合(持续补充中)

作者: 文娟_狼剩 | 来源:发表于2019-06-10 23:48 被阅读0次

1、Operation DROP USER failed for ''@'location' #操作删除用户失败

mysql删除语句单词写错了,正确的是drop user ''@'localhost'

MariaDB [(none)]> drop user ''@'location';
ERROR 1396 (HY000): Operation DROP USER failed for ''@'location'
MariaDB [(none)]> 

2、Access denied for user 'root'@'localhost' (using password: YES)" when trying to connect

用root”@“localhost”访问被拒绝

原因:密码错误

[root@web01 ~]# mysqldump -uroot -p -A >/root/all.sql
Enter password: 
mysqldump: Got error: 1045: "Access denied for user 'root'@'localhost' (using password: YES)" when trying to connect

相关文章

网友评论

      本文标题:【故障集合】MySQL错误集合(持续补充中)

      本文链接:https://www.haomeiwen.com/subject/squxfctx.html