MySQL Forums
Forum List  »  Newbie

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

Options: ReplyQuote




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.