mysql给新用授予权限Can't find any matching row in the user table

来源:互联网 发布:优雅的女生知乎 编辑:程序博客网 时间:2024/05/18 21:07
mysql> grant all privileges on *.* to newuser3@locahost ;ERROR 1133 (42000): Can't find any matching row in the user tablemysql> grant all privileges on *.* to newuser4@locahost identified by '1234';Query OK, 0 rows affected (0.00 sec)mysql>

要在末尾加上identified by ‘密码’ 就正常了。

0 1
原创粉丝点击