Troubleshooting of MySQL errors: Difference between revisions

Troubleshooting of MySQL errors (edit)

618 bytes removed , 12 May 2024

14,953

edits

@@ Line 235: / Line 235: @@
 INSERT IGNORE INTO `target`.`table` SELECT * FROM `source`.`table` LIMIT 0, 10000;
 </pre>
-== 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.
 == Database and Table Operation Errors ==