Home >Database >Mysql Tutorial >mysql 无lock tables权限 报Access denied for user when using_MySQL
mysql 无lock tables权限 报Access denied for user when using_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:43:561214browse
bitsCN.com
普通用户备份mysql 数据库报错
mysql 无lock tables权限 报Access denied for user 'dbuser'@'localhost' to database 'db' when using LOCK TABLES
主要原因是该用户无lock tables 该权限，处理办法：
1. 给该普通用户赋予lock tables 权限，建议是删除该用户，重新用mysql命令建
2. 加上--skip-lock-tables即可
mysqldump -udbuser -p dbname --skip-lock-tables > dbname.sql
3. 使用root 备份
摘自 依恋的专栏 bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql 主键自增长_MySQLNext article：Mysql中Profiling之性能分析_MySQL