不同版本多实例:
[root@localhost ~]# mkdir -p /data/3356/data /data/3357/data
[root@localhost ~]# chown -R mysql.mysql /data
[root@localhost ~]# cp /etc/my.cnf /etc/my3356.cnf
[root@localhost ~]# cp /etc/my.cnf /etc/my3357.cnf
[root@localhost ~]# vim /etc/my3356.cnf
[root@localhost ~]# vim /etc/my3357.cnf
[root@localhost ~]# cat /etc/my3356.cnf
[mysqld]
user=mysql
basedir=/usr/local/mysql56
datadir=/data/3356/data
server_id=56
port=3356
socket=/tmp/mysql56.sock
[root@localhost ~]# cat /etc/my3357.cnf
[mysqld]
user=mysql
basedir=/usr/local/mysql57
datadir=/data/3357/data
server_id=57
port=3357
socket=/tmp/mysql57.sock
[root@localhost opt]# tar xf mysql-5.6.50-linux-glibc2.12-x86_64.tar.gz
[root@localhost opt]# tar xf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
[root@localhost opt]# ln -s /opt/mysql-5.6.50-linux-glibc2.12-x86_64
/usr/local/mysql56
[root@localhost opt]# ln -s /opt/mysql-5.7.32-linux-glibc2.12-x86_64
/usr/local/mysql57
5.7版本初始化:
[root@localhost opt]# /usr/local/mysql57/bin/mysqld —defaults-
file=/etc/my3357.cnf —initialize-insecure
5.6版本初始化:
# /usr/local/mysql56/scripts/mysql_install_db —user=mysql —
basedir=/usr/local/mysql56 —datadir=/data/3356/data
启动:
[root@localhost opt]# /usr/local/mysql57/bin/mysqld_safe —defaults-
file=/etc/my3357.cnf &
[root@localhost opt]# /usr/local/mysql56/bin/mysqld_safe —defaults-
file=/etc/my3356.cnf &
[root@localhost opt]# mysql -S /tmp/mysql56.sock
[root@localhost opt]# mysql -S /tmp/mysql57.sock
[root@localhost opt]# mysql -S /tmp/mysql.sock
