admin
评论(0)
2021-01-11
数据库
导出：
mysqldump -u root -p table > 123.sql
导入：
mysql -uroot -p test1 < sql.sql
SQLSTATE[HY000]: General error: 1449 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)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
评论