Shulou(Shulou.com)06/02 Report--

The default port number of mysql is 3306. Beginners may sometimes forget or change the default port number, or very often we need to install two mysql on a computer or want to set a favorite number of our own, so let's take a look at how to view or modify the existing port number of mysql.

At the same time, click or win+R to open the run interface, enter cmd, or enter cmd in the search box of the start menu as shown in the figure.

After opening the DOS interface, enter the bin folder under the installation directory by entering the command, as shown in the figure

Enter the command line mysql shown in the figure. This is the name of the service. If the installed version is mysqld, if the decompressed version is set by yourself, enter the password to enter.

Type the query port number command line as shown in the figure, and then you will see the port number.

Then we open the my.ini configuration file under the installation directory folder and find the item shown in the figure to modify the port number you want to save (this is also a very simple way to view the current port number)

Then open the service in the computer management interface, find the service item, and click the restart option.

After rebooting, you can see that the command line I entered this time is not the same as before, that's because the port number is not the default, and you need to specify it here, and in the same way, you will see that the port number has changed.

Let's take a look at the MySQL port number command

Show global variables like 'port'

Summary

The above is the editor introduced to you under the Windows10 system to view the mysql port number and modify the tutorial diagram, I hope to help you, if you have any questions, please leave me a message, the editor will reply to you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.