During one of my last MySQL mission, I encountered a "security error" with mysqldump. The mission was about migrating a MySQL database from one box to another MySQL version and from Windows to Linux with different users. In order to do that, I used mysqldump. During the import of the data, I got the following warning:
ERROR 1449 (HY000) at line 1860: The user specified as a definer ('cdadmin'@'%') does not exist
Following the migration, I did the backup strategy. During the first mysql dump, I got the following error message:
mysql@mysql001: [mysqld2] mysqldump test
Running mysqldump for [Read more...]