Fixing MySQL Connection Refused Error

Diagnosis

The error 'SQLSTATE[HY000] [2002] Connection refused' typically occurs when the MySQL server is not reachable. This can be due to the server not running, incorrect connection settings, or network issues.

Solution

1. Check MySQL Server Status: Ensure the MySQL server is running. Use systemctl status mysql on Linux or check the service status on Windows.
2. Verify Connection Settings: Confirm the host, port, username, and password in your connection settings are correct.
3. Firewall and Network: Check if a firewall is blocking the MySQL port (default is 3306). Ensure network configurations allow connections to the MySQL server.
4. MySQL Configuration: Ensure bind-address in the MySQL configuration file (my.cnf or my.ini) is set to allow connections from your client.

Verification

After applying the solutions, attempt to reconnect to the MySQL server. Use a command-line client or application to verify the connection is successful.