14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
|||
| Line 185: | Line 185: | ||
</pre> | </pre> | ||
== ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused") | == ERROR 2003 (HY000): Can't connect to MySQL server on 'ip' == | ||
'''ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111 "Connection refused")''' | |||
Solution: | Solution: | ||
* Check if the MySQL service is running or not<ref>[https://www.cyberciti.biz/faq/how-to-find-out-if-mysql-is-running-on-linux/ HowTo: Find out If MySQL Is Running On Linux Or Not]</ref>. If not, start the MySQL service. | * Check if the MySQL service is running or not<ref>[https://www.cyberciti.biz/faq/how-to-find-out-if-mysql-is-running-on-linux/ HowTo: Find out If MySQL Is Running On Linux Or Not]</ref>. If not, start the MySQL service. | ||
'''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. | ||
| Line 200: | Line 202: | ||
References: | References: | ||
* [https://support.rackspace.com/how-to/mysql-connect-to-your-database-remotely/ Connect to a MySQL database remotely] | * [https://support.rackspace.com/how-to/mysql-connect-to-your-database-remotely/ Connect to a MySQL database remotely] | ||
* [http://wiki.navicat.com/wiki/index.php/Error_2003 Error 2003 - Navicat Wiki] | |||
* [http://faq.webyog.com/content/23/15/en/error-no-2003-can_t-connect.html SQLyog MySQL Admin FAQ - Error no. 2003: Can't connect...] | |||
== ERROR 2013: Lost connection to MySQL server during query == | == ERROR 2013: Lost connection to MySQL server during query == | ||