mysql 多端口配置_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的数据目录(确保磁盘空间足够)