14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→ERROR 2003 (HY000): Can't connect to MySQL server on 'ip'
| Line 198: | Line 198: | ||
** comment out [https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_skip-networking skip-networking] | ** comment out [https://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_skip-networking skip-networking] | ||
* 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 at (1) your personal computer (2) the server where MySQL service located (3) ISP/VM providers. More on [https://devops.profitbricks.com/tutorials/install-mysql-on-centos-7/#firewall-rules Install MySQL on CentOS 7 | ProfitBricks DevOps Central] | ||
** Check if your IP address was included in the allowed IP address list of firewall rules. | ** Check if your IP address was included in the allowed IP address list of firewall rules. | ||
** Check if your IP address was changed by using [https://whatismyipaddress.com/ What Is My IP Address?] services. | ** Check if your IP address was changed by using [https://whatismyipaddress.com/ What Is My IP Address?] services. | ||