How to Fix ERROR 1130 Error – ERROR 1130 (HY000): Host '' is not allowed to connect to this MySQL server

Method 1: Configure Firewall

1. Step 1: Open your terminal or command prompt and run the following command to find your current firewall settings:

sudo ufw status

Step 2:

1. Step 2: If your firewall is enabled, you'll see the current rules. To allow incoming connections from specific IP addresses, run the following command to add a new rule for each allowed IP address (replace xxx.xxx.xxx.xxx with your actual IP address):

sudo ufw allow from xxx.xxx.xxx.xxx to any port 3306

Method 2: Use MySQL Native Firewall Configuration

1. Step 1: Open your terminal or command prompt and run the following command to find your current MySQL native firewall configuration:

mysql -u root -ptest101 -h xxx.xxx.xxx.xxx --skip-lock-tables

Step 2:

1. Step 2: If your MySQL server is enabled, you'll see the current configuration. To enable incoming connections from specific IP addresses, run the following command to update the configuration file (replace xxx.xxx.xxx.xxx with your actual IP address):

mysql -u root -ptest101 -h xxx.xxx.xxx.xxx --skip-lock-tables -e 'SET GLOBAL innis_secure_file_priv = NULL;'

💡 Conclusion

By following these steps, you should be able to resolve the 'ERROR 1130 (HY000): Host '' is not allowed to connect to this MySQL server' error and successfully connect to your MySQL server.