How to Allow MySQL Client to Connect to Remote MySQL server Rumi, December 19, 2011 By default, MySQL does not allow remote clients to connect to the MySQL database. If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h 192.168.1.8 -u root -p Enter password: ERROR 1130: Host '192.168.1.4' is not allowed to connect to this MySQL server You can also validate this by doing telnet to 3306 mysql port as shown below, which will also give the same “host is not allowed to connect to this mysql server” error message as shown below. $ telnet 192.168.1.8 3306 host 192.168.1.4 is not allowed to connect to this mysql server If you want to allow a specific client ip-address (for example: 192.168.1.4) to access the mysql database running on a server, you should execute the following command on the server that is running the mysql database. $ mysql -u root -p Enter password: mysql> use mysql mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password'; mysql> FLUSH PRIVILEGES; Also, update firewall rules to make sure port# 3306 is open on the server that is running the mysql database. After the above changes, when you try to connect to the mysql database from a remote client, you’ll not get the “Host is not allowed to connect to this MySQL server” error message anymore. Related Configurations (Linux) MySQL MySQL
Neighbour table overflow February 10, 2012 If you have a big network with the hundreds of hosts you can expect “Neighbour table overflow” error which occurs in large networks when there are two many ARP requests which the server is not able to reply. For example you’re using server as a DHCP server, cable modems provisioning,… Read More
Nginx Reverse Proxying Multiple Domains Using map Module August 24, 2019 map_hash_bucket_size 128; map $http_host $backend_servers { hostnames; default www.example.com; frontend.example2.com backend.example2.com frontend.example3.com backend.example3.com www.example.org backend.example.org } proxy_set_header X-Real-IP $remote_addr; proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for; proxy_set_header Host $http_host; server { location / { proxy_pass http://$backend_servers } } Related Read More
Apache Virtual Hosts on Debian 8 March 9, 2018 Step 1 — Creating the Directory Structure The first step that we are going to take is to make a directory structure that will hold the site data that we will be serving to visitors. Our document root, the top-level directory that Apache looks at to find content to serve,… Read More