在服务器版本8.0.11 mysql上授予mysql的所有语法

okxuctiv  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(367)

怎么了

grant all privileges on apip.* to 'root'@'%'  IDENTIFIED BY PASSWORD 'rootadmin';

它给出了以下错误

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY PASSWORD 'rootadmin'' at line 1
pu82cl6c

pu82cl6c1#

IDENTIFIED BY 用户是否接受关键字 CREATE USER 命令,而不是 GRANT 命令。

相关问题