linux下mysql多端口配置记录

1、安装mysql

2、修改my.cnf

 在[mysqld_multi]中加入（需要几个端口就加几个）

[mysqld1]
port     = 3306
socket   = /tmp/mysql3306.sock
pid-file = /tmp/mysql3306.pid
datadir = /var/mysql/data
general_log = 1 
general_log_file = /var/mysql/log/mysql3306.log
skip-name-resolve
character-set-server    = utf8
back_log                = 50
max_connections         = 1024
max_connect_errors      = 32
max_allowed_packet      = 16M
table_cache             = 2048
binlog_cache_size       = 1M
max_heap_table_size     = 64M
tmp_table_size          = 64M

[mysqld2]
port     = 3307
socket   = /tmp/mysql3307.sock
pid-file = /tmp/mysql3307.pid
datadir = /var/mysql/3307data
general_log = 1
general_log_file = /var/mysql/log/mysql3307.log
skip-name-resolve
character-set-server    = utf8
back_log                = 50
max_connections         = 1024
max_connect_errors      = 32
max_allowed_packet      = 16M
table_cache             = 2048
binlog_cache_size       = 1M
max_heap_table_size     = 64M
tmp_table_size          = 64M

3、初始化(每个端口都需要初始化，生成sock文件)

 /usr/local/mysql/scripts/mysql_install_db --datadir=/var/mysql/3307data --user=mysql --basedir=/usr/local/mysql

4、启动mysql

/usr/local/mysql/bin/mysqld_multi --defaults-extra-file=/var/mysql/my.cnf start 1,2

5、分别授权

进入：mysql -u root -p -S /tmp/mysql3306.sock

增加用户并授权GRANT ALL PRIVILEGES ON *.* TOmysql@"%" IDENTIFIED BY 'mysql'

6、修改防火墙设置或者关闭防火墙，保证客户端能连接mysql

注意：

1、basedir:mysql的安装目录

2、datadir：mysql的数据目录（确保磁盘空间足够）