MySQL 多端口 For Linux

有2种情况,
1 同一个版本,启动多个端口
2 不同版本,启动多端口

同一版本启动多端口很简单
/usr/local/webserver/mysql/bin/mysqld_safe --defaults-file=/var/mysql3306/my.cnf  &

/usr/local/webserver/mysql/bin/mysqld_safe --defaults-file=/var/mysql3307/my.cnf  &

在my.cnf 里面

[client]
port    = 3306
socket    = /tmp/mysql.sock
default-character-set = utf8

[mysqld]
port    = 3306
socket    = /tmp/mysql.sock
default-character-set = utf8
basedir    = /usr/local/webserver/mysql
datadir    = /var/mysql/data


port,  socket  ,datadir  这三个目录区分开就行了, 比如
/var/mysql3306/my.cnf  里面这么写

引用

[client]
port    = 3306
socket    = /var/mysql3306/mysql.sock
default-character-set = utf8

[mysqld]
port    = 3306
socket    = /var/mysql3306/mysql.sock
default-character-set = utf8
basedir    = /usr/local/webserver/mysql
datadir    = /var/mysql3306/data
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

server-id  = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

---

/var/mysql3307/my.cnf  里面这么写

引用

[client]
port    = 3307
socket    = /var/mysql3307/mysql.sock
default-character-set = utf8

[mysqld]
port    = 3306
socket    = /var/mysql3307/mysql.sock
default-character-set = utf8
basedir    = /usr/local/webserver/mysql
datadir    = /var/mysql3307/data
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

server-id  = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

---

命令行下运行
/usr/local/webserver/mysql/bin/mysql -uroot -p123456 -S /var/mysql3306/mysql.sock

默认的 sock 是在 /tmp/mysql.sock ,如果换位置,基本所有的命令都需要 跟上 -S 来指定位置哦

---

不同版本,多库启动
按照 VPS安装  linux+nginx+php+mysql 打造自己的vps 里面数据库的安装,

--prefix=/usr/local/webserver/mysql/ 这个参数,换个目录就好了