LinkBack URL
About LinkBacksHi.
When i try to dump all my bases, i have this error:
Code:mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
Error on "mysqldump'
Hi.
When i try to dump all my bases, i have this error:
Code:mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
Re: Error on "mysqldump'
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.
cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
-- Tristan, Forums Technical Analyst, cPanel Tech Support
Submit a ticket | Check an existing ticket
Re: Error on "mysqldump'
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!
Reply With Quote