mysql> create user ‘root‘@‘%‘ identified by ‘密码‘;
Query OK, 0 rows affected (2.35 sec)

mysql> grant all privileges on *.* to ‘root‘@‘%‘;
Query OK, 0 rows affected (0.06 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.06 sec)

mysql8.0版本 the user specified as a definer ('root'@'%') does not exist问题解决