14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
m
→ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME'
| Line 157: | Line 157: | ||
Solution: | Solution: | ||
* Add the mysqldump option {{kbd | key=<nowiki>--skip-lock-tables</nowiki>}} if you cannot grant the user permissions. | * Add the mysqldump option {{kbd | key=<nowiki>--skip-lock-tables</nowiki>}} if you cannot grant the user permissions <ref>[https://stackoverflow.com/questions/7415698/skip-lock-tables-and-mysqldump mysql - skip-lock-tables and mysqldump - Stack Overflow]</ref>. | ||
<pre> | <pre> | ||
$ mysqldump -h 127.0.0.1 -u USER -p --skip-lock-tables DATABASE_NAME TABLE_NAME > TABLE_NAME.sql | $ mysqldump -h 127.0.0.1 -u USER -p --skip-lock-tables DATABASE_NAME TABLE_NAME > TABLE_NAME.sql | ||