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
Installing wkhtmltopdf on Debian 7.8 November 17, 2020July 17, 2021 Installing wkhtmltopdf on Debian 7.8 to dynamically create PDF documents from HTML. apt-get update aptitude install xfonts-base xfonts-75dpi fontconfig mkdir ~/src/wkhtmltopdf -p cd ~/src/wkhtmltopdf wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.2.1/wkhtmltox-0.12.2.1_linux-wheezy-amd64.deb dpkg -i wkhtmltox-0.12.2.1_linux-wheezy-amd64.deb Src: https://fedir.github.io/web/blog/2015/09/01/install-wkhtmltopdf-on-debian-7.8 https://github.com/wkhtmltopdf/wkhtmltopdf/releases/0.12.2.1/ https://github.com/wkhtmltopdf/packaging/releases/0.12.6-1 https://stackoverflow.com/questions/38262173/how-to-correctly-install-wkhtmltopdf-on-debian-64-bit Related Read More
Administrations Install gnome via tasksel on Debain 12 March 3, 2024 Tasksel is already installed on Debian 12, so you don’t need to install it. However, if for some reason tasksel is not installed on your system, you can install it via the command below sudo apt install tasksel To install Gnome via tasksel, you need first to run tasksel sudo… Read More
rkhunter perfect configuration January 4, 2015January 4, 2015 Introduction Exposing any computer to the internet is in some ways risky. There are many ways that your server can be compromised or attacked by remote systems and malicious software, and it is an ongoing and proactive process to defend yourself against potential threats. One potential concern is rootkits. Rootkits… Read More