Mysql The user specified as a definer ('root'@'%') does not exist 权限问题时

mac2025-09-27  26

在cmd 中 进入 mysql 的bin 目录 

1. 进入cmd:

mysql -u -p

2 .输入你的密码

3 .

grant all privileges on *.* to root@"%" identified by ".";

4.

flush privileges;

如果3提示:

You are not allowed to create a user with GRANT

继续使用

CREATE USER 'root'@'%' IDENTIFIED BY 'Hadoop3!'; grant all privileges on *.* to 'root'@'%';

就可以了 

 

最新回复(0)