Error
Error Code:
1130
MySQL Error 1130: Host Connection Denied
Description
This error indicates that the MySQL server has explicitly refused a connection attempt from a specific host. It typically occurs when the connecting client's IP address or hostname is not authorized by the MySQL server's user privileges or network configuration.
Error Message
Host '%s' is not allowed to connect to this MySQL server
Known Causes
4 known causesUser Not Granted Access for Host
The MySQL user account attempting to connect does not have privileges granted for the specific connecting host or IP address.
Incorrect User Host Definition
The MySQL user might be defined for a different host (e.g., 'user'@'localhost') and not for the actual remote host trying to connect.
Server Firewall Blocking
A firewall on the MySQL server machine or within the network path is preventing the incoming connection from the client host.
MySQL Server Network Configuration
The MySQL server might be configured to only listen on localhost (e.g., with skip-networking), effectively blocking all remote connections.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service