Search results
Simply open the configuration file in the terminal, sudo nano /etc/mysql/mysql.conf, and look for the [mysqld] section. In it, look for the line that reads port = 3306. Change it to another port not used and save the file.
Open port 3306 from Ubuntu Firewall UFW firewall is disabled by default in Ubuntu 18.04, so you don't have to worry about opening mysql port 3306 if you didn't enable UFW. But if have enabled UFW then it will block the mysql remote access, so you need to add firewall rule to open the port 3306.
sudo ufw allow from remote_IP_address to any port 3306. If you need to access the database from other machines in the future, you can grant them access on an ad hoc basis with this command. Just remember to include their respective IP addresses.
The output should show that MySQL Server is running on the socket 0 0.0.0.0:3306 instead of 127.0.0.1:3306. You can also try to telnet to the MySQL port 3306 from a remote host. For example, if the IP Address of your Ubuntu Server is 192.168.1.10, Then from the remote host execute, telnet 192.168.1.10 3306. You can also run the nmap command ...
12 wrz 2022 · Explains how to open and allow MySQL or MariaDB server TCP port number 3306 on a Linux operating system using iptables firewall admin tool.
13 lip 2020 · iptables -A INPUT -i enp1s0 -p tcp --destination-port 3306 -j ACCEPT. Alternatively you can grant access to specific ip address. iptables -A INPUT -i enp1s0 -s xxx.xxx.xxx.xxx -p tcp --destination-port 3306 -j ACCEPT. replace xxx.xxx.xxx.xxx with ip of the system from which you need to establish the connection.
4 lip 2024 · Option 1: Open Port 3306 using UFW (Uncomplicated Firewall) UFW is the default firewall tool in Ubuntu. In a terminal window, type the following command to allow traffic and match the IP and port: sudo ufw allow from remote_ip_address to any port 3306. Replace remote_ip_address with the actual IP of the system that needs to access MySQL.
