14,982
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
+ ERROR 1044 (42000)
(+ ERROR 1044 (42000)) |
|||
| Line 161: | Line 161: | ||
* Check the existence of file DATABASE\TABLE.frm. If not, you may need to create the TABLE before executed the MySQL query. | * Check the existence of file DATABASE\TABLE.frm. If not, you may need to create the TABLE before executed the MySQL query. | ||
* Check the permission of file DATABASE\TABLE.frm or folder which the file located<ref>[http://stackoverflow.com/questions/12106727/mysql-copying-tables-files-gives-rise-to-error-1017-hy000-cant-find-file MySQL, copying tables files gives rise to "ERROR 1017 (HY000): Can't find file:" even though its there there - Stack Overflow]</ref><ref>[https://www.percona.com/forums/questions-discussions/mysql-and-percona-server/2762-error-1017-hy000-can-t-find-file ERROR 1017 (HY000): Can't find file - Percona Community]</ref>. ''unverified'' | * Check the permission of file DATABASE\TABLE.frm or folder which the file located<ref>[http://stackoverflow.com/questions/12106727/mysql-copying-tables-files-gives-rise-to-error-1017-hy000-cant-find-file MySQL, copying tables files gives rise to "ERROR 1017 (HY000): Can't find file:" even though its there there - Stack Overflow]</ref><ref>[https://www.percona.com/forums/questions-discussions/mysql-and-percona-server/2762-error-1017-hy000-can-t-find-file ERROR 1017 (HY000): Can't find file - Percona Community]</ref>. ''unverified'' | ||
==== ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME' ==== | |||
Error message | |||
<pre> | |||
pv file.sql.gz | gunzip | mysql -u USER -p --host=127.0.0.1 --default_character_set utf8 DATABASE_NAME | |||
ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME' | |||
</pre> | |||
Solution: | |||
* Check the permission of specified user name & database name | |||
==== ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) ==== | ==== ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) ==== | ||