mysql5.7多实例安装

cd /home/chenenhui

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.14-linux-glibc2.5-x86_64.tar

#rm -rf /usr/local/mysql*

cd /home/chenenhui

tar xf mysql-5.7.14-linux-glibc2.5-x86_64.tar.gz -C /usr/local/

cd /usr/local/

ln -sv /usr/local/mysql-5.7.14-linux-glibc2.5-x86_64 mysql

ln -s /usr/local/mysql/bin/mysql /usr/bin

cd /usr/local/mysql

useradd -r mysql

chown -R root.mysql ./

rm -rf /data/mysql3306*

mkdir -p /data/mysql3306/mysqldata

mkdir -p /data/mysql3306/logs

mkdir -p /data/mysql3306/binlog

mkdir -p /data/mysql3306/logs

mkdir -p /data/mysql3306/undo

cd /data

chown -R mysql.mysql ./

/usr/local/mysql/bin/mysqld --defaults-file=/etc/mysql/my3306.cnf --initialize-insecure --user=mysql

/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql/my3306.cnf --user=mysql &

mysql -hlocalhost -uroot -p --socket=/data/mysql3306/logs/mysql.sock

UPDATE mysql.user SET authentication_string = PASSWORD('123456') WHERE USER LIKE '%root%';

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

flush privileges;

退出后可以 mysql -h127.0.0.1 -uroot -p -P3306

mkdri -p /data/mysql3307

rm -rf /data/mysql3307

mkdir -p /data/mysql3307/mysqldata

mkdir -p /data/mysql3307/logs

mkdir -p /data/mysql3307/binlog/

mkdir -p /data/mysql3307/logs/

mkdir -p /data/mysql3307/undo/

cd /data

chown -R mysql.mysql ./

/usr/local/mysql/bin/mysqld --defaults-file=/etc/mysql/my3307.cnf --initialize-insecure --user=mysql

/usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/mysql/my3307.cnf --user=mysql &

mysql -hlocalhost -uroot -p --socket=/data/mysql3307/logs/mysql.sock

UPDATE mysql.user SET authentication_string = PASSWORD('123456') WHERE USER LIKE '%root%';

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

flush privileges;

退出后可以 mysql -h127.0.0.1 -uroot -p -P3307

# 关闭防火墙以便外界可以访问mysql

iptables -L -n -v

service iptables stop

getenforce

setenforce 0

iptables -L -n -v

service iptables save

history