Mysql does not have lock tables permission to report to Access denied for user when using how to solve the problem.

This article mainly introduces "mysql does not have lock tables authority to report Access denied for user when using how to solve". In daily operation, I believe that many people have doubts about how to solve problems when mysql does not have lock tables authority to report Access denied for user when using. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubt that "mysql does not have lock tables authority to report Access denied for user when using". Next, please follow the editor to study!

Ordinary users report error when backing up mysql

Do not have lock tables permission to report Access denied for user' dbuser'@'localhost' to database 'db' when using LOCK TABLES

The main reason is that the user does not have the permission to lock tables. How to deal with it:

1. Give the ordinary user lock tables permission. It is recommended to delete the user and re-use the mysql command to create

two。 Just add-- skip-lock-tables

Mysqldump-udbuser-p dbname-- skip-lock-tables > dbname.sql

3. Backing up with root

At this point, the study on "mysql does not have lock tables authority to report how to solve Access denied for user when using" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!