mysql 报错

Question

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY `447653cfde`  WITH GRA
NT OPTION;
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 `447653cfde`  WITH GRANT OPTION' at line 1

怎么解决？

Answer 1

lulye 2022-11-06 15:11:42

解决grant 授权报not allowed to create user with grant:

create database vueshop;  #创建数据库

alter user vueshop identified with mysql_native_password by 'xxx'；  # XXX为修改的用户vueshop的密码

grant all privileges on vueshop.* to 'vueshop'@'%' ;  # 授权

flush privileges;  #刷新权限

下载视频          

Answer 2

bobby 2022-09-05 21:55:25

你的mysql版本是多少？  如果版本没有问题  

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'root' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;

FLUSH PRIVILEGES;

确定一下是用的是这些命令吧