Menu
I want to disable outside connections to my mysql in debian, with firewall. i only know that it has to be inside the iptables.test.rules file
Thanks in advance.
936
To allow remote access to MySQL, you have to comment out bind-address (you did) and skip-networking in the configuration file. Next, you have to make sure the user is allowed remote access. Check your user with this: SELECT User, Host FROM mysql.
normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.
The best way to disable external connections to your MySQL is setting bind-address=127.0.0.1 in my.cnf configuration file. If you still need to block MySQL external access using firewall, you drop or reject all packets sending to 3306 port.
81
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
