ServerTune

Browse by category

Search    |    Advanced search

Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

If you get this error, do the following:

Add --single-transaction option to mysqldump command:

Another option is to grant LOCK TABLES to your user:

Enter the following syntax at MySQL prompt:

 
 
Add comment
 
Views: 1877
 
Votes: 0
 
Comments: 0
 

Other articles in this Category

RSS