For example, on Linux, the default location is /etc/mysql/my.cnf (the file can also be located in /var/lib/mysql/bin/my.cnf or other locations, such as /etc/my.cnf, /var/bin/mysql/mysql*.*.** where the wildcards represent your MySQL version or even in your data directory.) The location of the configuration file varies based on the operating system and the installation method. However, it is recommended to use a port number above 1024, as the lower port numbers are reserved for system services. Determine the port number you want to use.Updating the Port Number in the MySQL Configuration File You can either change the port number in the MySQL configuration file or specify the port number when connecting to the MySQL server. The process of configuring ports for MySQL is straightforward. This can cause a conflict and lead to unexpected errors. If an application is already using the port, you will not be able to start the MySQL server on that port. When setting up ports for MySQL, it is important to ensure that the port is not being used by any other application. However, this port can be changed to any other available port. The default port number for MySQL is 3306. In MySQL, ports are used to establish communication between the MySQL server and the client applications.
Nmap done: 1 IP address (1 host up) scanned in 0.A port is a communication endpoint through which data is sent and received. Then after restart mysql with sudo systemctl restart mysql, you should be able to telnet from an external server. You mentioned you did this, but just to confirm: Add bind-address = 0.0.0.0, like it mentions, and also comment out bind-address = 127.0.0.1 by placing the # in front: I just tested this out and it worked successfully. ``` If you're trying to reach mysql over port 3306 from an external location, then yes, you'll need change the bind address in my.cnf, similar to what's outlined here: Then after restart mysql with `sudo systemctl restart mysql`, you should be able to telnet from an external server. You mentioned you did this, but just to confirm: Add `bind-address = 0.0.0.0`, like it mentions, and _also_ comment out `bind-address = 127.0.0.1` by placing the `#` in front: > Try to add bind-address = 0.0.0.0 to your section of your my.cnf and restart mysqld. Nmap done: 1 IP address (1 host up) scanned in 0.51 secondsĭescription If you're trying to reach mysql over port 3306 from an external location, then yes, you'll need change the bind address in `my.cnf`, similar to what's outlined here:
Try to add bind-address = 0.0.0.0 to your section of your my.cnf and restart mysqld.
If you're trying to reach mysql over port 3306 from an external location, then yes, you'll need change the bind address in my.cnf, similar to what's outlined here:
0 kommentar(er)
