mysql 提示 1133Can't find any matching row in the user table
小虾米
阅读:2445
2021-03-31 21:21:39
评论:0
今天通过Native for mysql 工具添加一个用户,并且为这个用户赋值相关数据库的只读权限,提示如下错误“1133 - Can't find any matching row in the user table”
我的Native for mysql 相关语句
INSERT INTO mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) VALUES("localhost","test",PASSWORD("123456"),"","","");
grant select on `master`.* to test@localhost identified by '123456';
执行插入用户语句没有问题,但是执行权限赋值的时候提示:1133 - Can't find any matching row in the user table;
解决办法:插入新的用户成功时,需要刷新(flush privileges;)下mysql 权限列表。正确mysql5.6 插入用户,并为用户赋值相关用户权限。
INSERT INTO mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) VALUES("localhost","test",PASSWORD("123456"),"","","");
flush privileges;
grant select on `master`.* to test@localhost identified by '123456';
声明
1.本站遵循行业规范,任何转载的稿件都会明确标注作者和来源;2.本站的原创文章,请转载时务必注明文章作者和来源,不尊重原创的行为我们将追究责任;3.作者投稿可能会经我们编辑修改或补充。