14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME'
mNo edit summary |
|||
| Line 137: | Line 137: | ||
== ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME' == | == ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME' == | ||
Message: | Message: {{kbd | key=<nowiki>ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME'</nowiki>}} | ||
<pre> | <pre> | ||
pv file.sql.gz | gunzip | mysql -u USER -p --host=127.0.0.1 --default_character_set utf8 DATABASE_NAME | pv file.sql.gz | gunzip | mysql -u USER -p --host=127.0.0.1 --default_character_set utf8 DATABASE_NAME | ||
</pre> | </pre> | ||
| Line 150: | Line 149: | ||
mysql> use DATABASE_NAME | mysql> use DATABASE_NAME | ||
</pre> | |||
Message: {{kbd | key=<nowiki>mysqldump: Got error: 1044: Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME' when doing LOCK TABLES</nowiki>}} | |||
<pre> | |||
$ mysqldump -h 127.0.0.1 -u USER -p DATABASE_NAME TABLE_NAME > TABLE_NAME.sql | |||
</pre> | |||
Solution: | |||
* Add the mysqldump option {{kbd | key=<nowiki>--skip-lock-tables</nowiki>}} if you cannot grant the user permissions. | |||
<pre> | |||
$ mysqldump -h 127.0.0.1 -u USER -p --skip-lock-tables DATABASE_NAME TABLE_NAME > TABLE_NAME.sql | |||
</pre> | </pre> | ||