Error on "mysqldump'

[Astral God]

Hi.

When i try to dump all my bases, i have this error:

mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

 

[cPanelTristan]

If you google the error online, you'll find discussions of it such as the following:

mysqldump: Got error: 1044: Access denied for user ‘root’@’localhost’ to database ‘information_schema’ when using LOCK TABLES

This is not a cPanel-related issue but due to the MySQL user not having LOCK TABLES rights set on the database table.

 

[manokiss]

Hi Tristan, in fact this looks like a cpanel issue in the mysql version update process.....we have upgraded from 5.0 to 5.1 recentrly and we have a mysql backup script doing mysqldump every day, did start erroring with that message....wasnt happening with 5.0. Looks like after the update root do not have the right to lock tables. so basically you have turn on unprivileged mode grant to root the permission and then turn off unprivileged mode. Wondering if you have any fix for this, dealing with mysql permissions by hand is a bit risky. Thanx!