mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES
当出现下面错误时:
mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES
是权限问题,解决办法,执行两条SQL语句就好:
grant all privileges on *.* to root@"%" identified by "."; flush privileges;
在命令中执行图:
mysql> grant all privileges on *.* to root@"%" identified by "."; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)
正在加载评论...
相关文章
- mysql做时间排序时查询很慢,给时间字段添加索引后...
- Unable to connect to remote host. Catalog downl...
- 在sql做order by排序时,又让特定的数据排在最前面
- You must reset your password using ALTER USER s...
- 绿色免安装版mysql下载地址及环境变量设置图解
- MySQL将指定数据有逗号分隔的,拆分成多条(即行转...
- java.sql.SQLException: No suitable driver found...
- ON DUPLICATE KEY UPDATE的用法
- mysql用navicat导出数据库报1577错误记录