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

Let's talk about the default port number modification method for mysql. The secret of the text is that it is close to the topic. So, forget the gossip, let's go straight to the following, and I'm sure you'll benefit from reading this article on mysql's default port number modification.

To change the default port number for mysql:

1. Find the my.ini of the MYSQL installation directory

2. Open the my.ini file and modify the port port. Ctrl+F directly, search for port, as shown in the figure

3306 is the default port number of MySQL, change it to the port number you want, and note that you need to change both places; save and close after the modification is completed.

3. Restart the mysql service

How to restart the mysql service:

Win+r starts-run-cmd, stop service: net stop mysql restart service: net start mysql

Or restart manually

Right-click my computer-- > Administration-- > Services and applications-- > Services-- > mysql-- > right-click restart

Is there anything you don't understand about the default port number modification method of the above mysql? Or if you want to know more about it, you can continue to follow our industry information section.

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.