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

Editor to share with you how to view the MySQL port under Linux, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The port for MySQL defaults to 3306, but the MySQL port may have been modified during installation.

1. Log in to mysql

[root@localhost ~] # mysql-uroot-pEnter password: enter the database password

2. Use the show global variables like 'port'; command to view the port number

Mysql > show global variables like 'port';+-+---+ | Variable_name | Value | +-+-- + | port | 3306 | +-+-- + 1 row in set (0.00 sec)

Mysql >

3306 is the port number.

Second, the modification of MySQL port number

1. Edit / etc/my.cnf file [root@localhost ~] # vi / etc/my.cnf

2. Add port=2032

3. Restart mysql [root@localhost ~] # / etc/init.d/mysqld restart

The above is all the contents of the article "how to View MySQL Ports under Linux". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.