Tips for viewing port usage in Windows

You may often encounter a port numberProgramIn this case, the first idea is to see which program is occupied. Some dedicated gadgets can be viewed, but netstat can also be used:

Netstat-ano, where the O parameter is used to view the PID of the program that occupies the port number, then we can find the program through the Task Manager (you need to select the PID in "View"> "Select column" of the task manager)

 

By the way, record the usage of the MySQL command to be noted:

Show index from tablename; drop index index_name on table_name;