MySQL5.7端口修改指南（mysql5.7修改端口）

MySQL 5.7 is an open-source relational database management system (RDBMS) developed by Oracle. As it is an enterprise level database system, the safety of the data stored in it is of utmost importance. It is essential to maintain a secure configuration of the database and assets to ensure that unauthorized users do not gain access to the data. One of the ways of ensuring the security of a MySQL 5.7 server is to regularly change the port on which it listens for connections.

In this guide, we will walk through the steps of changing the MySQL 5.7 port from its default to a different port. Please note that it is not recommended to leave the default port as it is a potential security risk.

The first step is to open the “my.cnf” file, which is a configuration file that is used by MySQL. It is usually located at “/etc/my.cnf” in Linux systems and “C:\Program Files \MySQL \MySQL Server 5.7 \my.ini” in Windows systems.

Once the file has been opened, search for the line that begins with “port =” and modify the number after it. This is the port that is used by MySQL server. Save the changes and restart MySQL after making the changes.

The second step is to open the “Windows Firewall” control panel and add an exception for the new port. Go to “Advanced Settings”, click on “Inbound Rules” and click on “New Rule”. Select “Port”, click “Next” and enter the new port number in “Specific Local Ports”. Select “Allow the Connection” and click “Next”. Select all the profiles for which the changes must be applied and click “Finish”.

It is important to test if the changes have been applied correctly. To do this, use the “telnet” command in the Command Prompt or Terminal window to connect to the MySQL server on the new port. If the connection is successful, it means that the changes have been applied correctly.

In conclusion, changing the default port of MySQL 5.7 server is an important security measure and requires a few steps. First, modify the “my.cnf” file and restart MySQL after the changes have been saved. Second, add an exception for the new port in Windows Firewall. And third, use the “telnet” command to test if the changes have been applied correctly.