14,982
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Troubleshooting of MySQL
| Line 150: | Line 150: | ||
* Check the typo of password. | * 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> | ||
* You may need to delete the existing account setting and re-config again. | |||
==== Err 1054 - Unknown column in 'where clause' ==== | ==== Err 1054 - Unknown column in 'where clause' ==== | ||
| Line 234: | Line 234: | ||
==== ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (116 "Connection timed out") ==== | ==== ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (116 "Connection timed out") ==== | ||
Solution: | Solution: | ||
* Check the permission of MySQL database user. | * Check the permission of MySQL database user. | ||
* Check the firewall rules. More on [https://devops.profitbricks.com/tutorials/install-mysql-on-centos-7/#firewall-rules Install MySQL on CentOS 7 | ProfitBricks DevOps Central] | * Check the firewall rules. More on [https://devops.profitbricks.com/tutorials/install-mysql-on-centos-7/#firewall-rules Install MySQL on CentOS 7 | ProfitBricks DevOps Central] | ||
| Line 271: | Line 271: | ||
==== resolve insufficient hard disk space where mysql data located ==== | ==== resolve insufficient hard disk space where mysql data located ==== | ||
[http://errerrors.blogspot.tw/2016/07/mysql.html Err: 解決 MySQL 資料庫所在硬碟空間不足的狀況] | [http://errerrors.blogspot.tw/2016/07/mysql.html Err: 解決 MySQL 資料庫所在硬碟空間不足的狀況] | ||
=== further reading === | === further reading === | ||