centos中mysql多实例安装 (原创)

#解压安装包

tar -zxvf mysql-8.0.21-el7-x86_64.tar.gz

#创建安装根目录
mkdir -p /data/local
cp -rf   mysql-8.0.21-el7-x86_64  /data/local/
cd /data/local/
mv mysql-8.0.21-el7-x86_64 mysql8 


cd /data/local/mysql8 
mkdir data #创建数据mysql的data目录

给新的mysql目录所属用户分配为mysql账户

chown -R mysql:mysql   /data/local/mysql8

mysqld]     
port=3307 
basedir=/data/local/mysql8 
datadir=/data/local/mysql8/data
  
socket=/data/local/mysql8/mysql.sock
#允许连接失败的最大次数  
max_connect_errors=100  
#服务端的字符集编码  
character-set-server=utf8 
#默认存储引擎  
default-storage-engine=INNODB 
#默认用户  
user=mysql  
lower_case_table_names=1
max_connections = 2000

mysqlx=0
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

vi ./support-files/mysql.server，修改basedir 、datadir等配置信息

    找到 conf=/etc/my.cnf ，进行修改。

#初始化mysql  
./bin/mysqld --defaults-file=/data/local/mysql8/my.cnf --lower-case-table-names=1 --initialize  --console --user=mysql
得到临时密码：如 P8Lp&Vp7nD)A

启动服务

cd /data/local/mysql8

./bin/mysqld_safe --defaults-file=./my.cnf &

mysql客户端连接

修改root的密码，

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456abc';

create user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456abc';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO 'root'@'%';

停止mysql服务

./bin/mysql --socket=./mysql.sock -uroot -p #先连上mysql服务

 mysql>  shutdown ;