How to query the port in mysql

In mysql, you can use the show command to view the port. The function of this command is to view some MySQL parameters, databases, tables, columns, indexes and other information. The syntax is "show global variables like 'port'".

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How does mysql query the port

Enter the command line mysql -u root -p in the dos interface. If the version number and other contents in the picture appear, it means that the mysql service has been connected

At this time, enter show global variables like 'port'; to view the port number

Know the port number If you need to continue to enter other content later, you can ctrl c to exit the current state

Recommended learning: mysql video tutorial

The above is the detailed content of How to query the port in mysql. For more information, please follow other related articles on the PHP Chinese website!