How to change the connection port in mysql

Mysql method to change the connection port: first log in to mysql; then use the command [show global variables like 'port';] to view the port number; then modify the port; and finally restart mysql.

【Related learning recommendations:mysql tutorial(Video)】

Mysql method to change the connection port:

1. Log in to mysql

mysql -u root -p //输入密码

2. Use the commandshow global variables like 'port';Check the port number

mysql> show global variables like 'port';

3. Modify the port

Edit the /etc/my.cnf file. In earlier versions, it may be the my.conf file name, and add port parameters. , and set the port. Note that the port is not used, save and exit.

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

4. Restart mysql

[root@test ~]# /etc/init.d/mysqld restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ]

If you want to learn more about programming, please pay attention to thephp trainingcolumn!

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