Astral God

Well-Known Member
Sep 27, 2010
180
0
66
127.0.0.1
cPanel Access Level
Root Administrator
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
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
44
348
somewhere over the rainbow
cPanel Access Level
Root Administrator

manokiss

Well-Known Member
Mar 31, 2002
576
1
318
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!