MySQL 5.7 multi-instance installation

The server already has MySQL 5.6 running, want to learn MySQL 5.7 new features, found installation 5.7 when various pits, so record under in case forget

installing MySQL 5.7

Groupadd MySQL

Useradd-r-G MySQL MySQL

TAR-XF mysql-5.7.9-linux-glibc2.5-x86_64

Cp-r mysql-5.7.9-linux-glibc2.5-x86_64/opt

Cd/opt

LN-SV mysql-5.7.9-linux-glibc2.5-x86_64/mysql57

CD mysql57/

# # Create Data Catalog

Mkdir-p/data/mysql57

Chown-r mysql.mysql/data/mysql57

CP support-files/my-default.cnf MY.CNF

VI my.cnf #配置下面几项

Basedir =/opt/mysql57

DataDir =/data/mysql57

Port = 3357

server_id = 33571

Socket =/tmp/mysql57.sock

Bin/mysqld--initialize--user=mysql--basedir=/opt/mysql57--datadir=/data/mysql57--defaults-file=/opt/mysql57/ My.cnf

Bin/mysql_ssl_rsa_setup

CP support-files/mysql.server/etc/init.d/mysqld57

vim/etc/init.d/mysqld57

Basedir= '/opt/mysql57 '

Datadir= '/data/mysql57 '

This article is from the "Silent Learning" blog, please be sure to keep this source http://mzs0207.blog.51cto.com/1874062/1712077

MySQL 5.7 multi-instance installation