Linux环境下修改MYSQL端口

1.登录Mysql

[root@test /]# mysql -u root -p  
Enter password:  

2.使用命令查看端口号

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

3.修改端口，编辑/etc/my.cnf文件。

[root@test etc]# vi my.cnf  
[mysqld]  
port=3506  
datadir=/var/lib/mysql  
socket=/var/lib/mysql/mysql.sock  
user=mysql 
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.重新启动mysql

[root@test ~]# /etc/init.d/mysqld restart  或 service 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  

6.再次查看端口号

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

注意：只有重新启动mysql数据库后端口才真正被改变