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