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

Editor to share with you how to change the connection port of mysql, I believe that 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!

Mysql changes the connection port by first logging in to mysql; and then using the command [show global variables like 'port';] to check the port number, then modifying the port, and finally restarting mysql.

[recommended for related study: mysql tutorial (video)]

How mysql changes the connection port:

1. Log in to mysql

Mysql-u root-pram / enter password

two。 Use the command show global variables like 'port'; to view the port number

Mysql > show global variables like 'port'

3. Modify Port

Edit the / etc/my.cnf file, the previous version may be the my.conf file name, add port parameters, and set the port, note that the port is not used, save exit.

[root@test etc] # vi my.cnf [mysqld] port=3506datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid "my.cnf" 11L, 261C written [root@test etc] #

4. Restart mysql

[root@test] # / etc/init.d/mysqld restartStopping mysqld: [OK] Starting mysqld: [OK] these are all the contents of mysql's method of changing the connection port. 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.