mysql能有多个端口吗_同一台MySQL服务器启动多个端口

由于工作需要，现需要在同一台服务器上同时开启多个mysql端口，操作主要如下：

1.首先要先把my.cnf配置文件复制一份，开几个端口要复制几份当然要重新命名

如：cp /etc/my.cnf /etc/my_1.cnf

cp /etc/my.cnf /etc/my_2.cnf

cp /etc/my.cnf /etc/my_3.cnf

2.修改my_1.cnf my_2.cnf my_3.cnf文件把默认的3306端口改成 3307 3308 3309.

3.数据库指定存放数据的目录也要重新复制

cp /usr/local/mysql/var /usr/local/mysql/var1 (这里是默认的存放目录)

cp /usr/local/mysql/var /usr/local/mysql/var2

cp /usr/local/mysql/var /usr/local/mysql/var3

4.因为目录变了 要重新初始化数据库

/usr/local/mysql//bin/mysql_install_db --datadir=/usr/local/mysql/var1 --user=mysql

/usr/local/mysql//bin/mysql_install_db --datadir=/usr/local/mysql/var2 --user=mysql

/usr/local/mysql//bin/mysql_install_db --datadir=/usr/local/mysql/var3 --user=mysql

5.启动mysql，当然这里要指定.cnf文件和目录启动

/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my_1.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var1 --user=mysql &

/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my_2.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var2 --user=mysql &

/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my_3.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var3 --user=mysql &

大功告成，自己快去试试吧。