Troubleshooting of MySQL errors: Difference between revisions

Jump to navigation Jump to search
Line 244: Line 244:
* 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 1049 (42000): Unknown database ==
Message: ERROR 1049 (42000): Unknown database 'MY_DATABASE_p'
Solution:
* 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.


== Database and Table Operation Errors ==
== Database and Table Operation Errors ==

Navigation menu