14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)
| Line 92: | Line 92: | ||
</pre> | </pre> | ||
== ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) | == ERROR 1045 (28000): Access denied for user == | ||
Message: ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) | |||
Solution: | Solution: | ||
* Check the typo of user name. | * Check the typo of user name. | ||
| Line 98: | Line 100: | ||
* If you are using the console command, escape the password if it contains special characters e.g. {{kbd | key=<nowiki>mysql -u root -p'PASSWORD'</nowiki>}}<ref>[http://superuser.com/questions/123928/escaping-a-password-using-mysqldump-console escape characters - Escaping a password using mysqldump console - Super User]</ref> | * If you are using the console command, escape the password if it contains special characters e.g. {{kbd | key=<nowiki>mysql -u root -p'PASSWORD'</nowiki>}}<ref>[http://superuser.com/questions/123928/escaping-a-password-using-mysqldump-console escape characters - Escaping a password using mysqldump console - Super User]</ref> | ||
* You may need to delete the existing account setting and re-config again. | * You may need to delete the existing account setting and re-config again. | ||
== Error!: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied == | |||
Message: Error!: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user 'user'@'localhost' (using password: YES) | |||
Solution: | |||
* If you executed the query{{kbd | key=INTO OUTFILE}}, you need to grant the file permission e.g. {{kbd | key=GRANT FILE ON *.* TO 'user'@'localhost';}}<ref>[https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_file MySQL :: MySQL 5.7 Reference Manual :: 6.2.1 Privileges Provided by MySQL]</ref><ref>[https://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold MYSQL into outfile "access denied" - but my user has "ALL" access.. and the folder is CHMOD 777 - Stack Overflow]</ref>. | |||
== ERROR 1054 - Unknown column in 'where clause' == | == ERROR 1054 - Unknown column in 'where clause' == | ||