ERROR 3554 (HY000) while importing a .sql dump file



. min read


ERROR 3554 (HY000) at line 318: Access to system table 'mysql.innodb_index_stats' is rejected. 

You'll need to make a new dump/backup of your old database, Remove innodb tables from your target. 

You can do this by using-- ignore-table parameter on the command line:

mysqldump -u root -p --all-databases --ignore-table=mysql.innodb_index_stats --ignore-table=mysql.innodb_table_stats > db_backup.sql

Restore your backup on the new database using the command below:

mysql -u root -p < db_backup.sql