mysql查看当前启动的端口号

最新推荐文章于 2024-07-03 03:40:59 发布

原创最新推荐文章于 2024-07-03 03:40:59 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

mysql 专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍了如何在MySQL中查看并修改默认端口号，包括登录MySQL、使用命令查看端口号、编辑配置文件my.cnf来修改端口、重启MySQL服务以及验证端口修改是否成功的过程。

mysql 查看并修改默认端口号

登录mysql
[root@test /]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 92
Server version: 5.1.66 Source distribution

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’;查看端口号

修改端口，编辑/etc/my.cnf文件，早期版本有可能是my.conf文件名，增加端口参数，并且设定端口，注意该端口未被使用，保存退出。

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]#

重新启动mysql

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

5.再次登录后检查端口已修改为’3506’.

root@test etc]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.66 Source distribution

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>