15,024
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→Access and Authentication Errors
| Line 308: | Line 308: | ||
* Check the database 'MY_DATABASE_p' is exists | * Check the database 'MY_DATABASE_p' is exists | ||
* Check there are no {{kbd | key=TAB}} character after database name if you want to connect the database 'MY_DATABASE' when you are using console. | * Check there are no {{kbd | key=TAB}} character after database name if you want to connect the database 'MY_DATABASE' when you are using console. | ||
=== ERROR 1045 (28000): Access denied for user === | |||
Message: ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) | |||
Solution: | |||
* Check the typo of user name. | |||
* Check the typo of password. | |||
* 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. | |||
== SQL and Query Errors == | == SQL and Query Errors == | ||