10
Oct 2009
MySQL information_schema error when using mysqldump utility
Posted in Mysql by sibu at 10:54 am |
While executing the mysqldump command you may have experienced following errors.
mysqldump: Got error: 1044: Access denied for user ‘root’@'localhost’ to database ‘information_schema’ when using LOCK TABLES
To quickly fix this problem use the following switch when running mysqldump for MySQL database backups.
mysqldump -u root -p -all-databases -single-transaction > all.sql
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.