数据库重装提示没办法保存。提示The user specified as a definer ('root'@'%') does not exist
此时只要给权限就可以了。如下操作:
权限问题,授权 给 root 所有sql 权限
mysql> grant all privileges on *.* to root@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec);
或者用navicat 执行上面语句也可以。
数据库重装提示没办法保存。提示The user specified as a definer ('root'@'%') does not exist
此时只要给权限就可以了。如下操作:
权限问题,授权 给 root 所有sql 权限
mysql> grant all privileges on *.* to root@"%" identified by ".";
Query OK, 0 rows affected (0.00 sec);
或者用navicat 执行上面语句也可以。