ERROR: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
Posted by:
Bob Bader
Date: August 10, 2006 12:53PM
I installed mysql 5.0.24 and got my databases imported.
I am setting up backup when I run the command I get the error:
----------------
./mysqldump --user root -p --all-databases --lock-tables > /full_db_backup
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
If I run the command without the –lock-tables I still ge the same error
---------------------
fry:/usr/local/mysql/bin root# ./mysqldump --user root -p --all-databases > /full_db_backup
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
I am a newbie and I understand the information_schema database is a system databse,
If I run the command for just that schema I do NOT get the error.
./mysqldump --user root -p information_schema > /full_db_backup
Any Ideas?
Thanks
Bob
Subject
Written By
Posted
ERROR: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
August 10, 2006 12:53PM
December 01, 2007 03:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.