13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES)
| Line 158: | Line 158: | ||
==== ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) ==== | ==== ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) ==== | ||
Solution: | Solution: | ||
* Check the password. | * Check the typo of user name. | ||
* Check the typo of password. | |||
* 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> | * 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> | ||