Error
Error Code:
1130
MariaDB Error 1130: Host Access Denied
Description
This error indicates that the MariaDB server has explicitly denied a connection attempt from a specific host or IP address. It commonly occurs when the connecting user's permissions do not include the client's origin or due to server-side network restrictions.
Error Message
Host '%s' is not allowed to connect to this MariaDB server
Known Causes
4 known causesUser Host Mismatch
The MariaDB user attempting to connect is not granted privileges for the specific host or IP address from which the connection originates.
Server Bind Address Restriction
The MariaDB server's configuration (`bind-address`) restricts incoming connections to specific network interfaces or IP addresses, excluding the client's IP.
External Firewall Block
A network firewall (either on the server, client, or in between) is blocking the connection to the MariaDB server's port.
Incorrect DNS Resolution
If connecting by hostname, the server might fail to resolve the client's hostname correctly, or the resolved IP doesn't match the user's granted host.
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