MySQL修改端口

「爱情、让人受尽委屈。」 2023-01-13 08:57 188阅读 0赞

### 文章目录 ###

*  一、mysql 查看端口
 *  二、netstat 查看端口
 *  三、修改my.cnf
 *  四、重启mysql
 *  五、netstat 再次查看

# 一、mysql 查看端口 #

[root@localhost ~]# mysql -u root -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 723
    Server version: 5.7.33 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2021, Oracle and/or its affiliates.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> show global variables like 'port';
    +---------------+-------+
    | Variable_name | Value |
    +---------------+-------+
    | port          | 3306  |
    +---------------+-------+
    1 row in set (0.01 sec)
    
    mysql> exit
    Bye

# 二、netstat 查看端口 #

[root@localhost ~]# netstat -nplt
    Active Internet connections (only servers)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
    tcp6       0      0 :::3306                 :::*                    LISTEN      3115/mysqld         
    tcp6       0      0 :::6379                 :::*                    LISTEN      1852/redis-server *

# 三、修改my.cnf #

vim /etc/my.cnf

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2thbmd3ZWlqaWFu_size_16_color_FFFFFF_t_70]

# 四、重启mysql #

systemctl restart mysqld

# 五、netstat 再次查看 #

[root@localhost ~]# netstat -nplt
    Active Internet connections (only servers)
    Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
    tcp6       0      0 :::19306                :::*                    LISTEN      25953/mysqld        
    tcp6       0      0 :::6379                 :::*                    LISTEN      1852/redis-server *

***觉得好，就一键三连呗（点赞+收藏+关注）***

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2thbmd3ZWlqaWFu_size_16_color_FFFFFF_t_70]: /images/20221022/ba01f2c236a146e1bfd91e4dfcb48ce4.png