Yum本地安装MySQL8.0 .20

rpm包已经放在/root/mysql

cd /root/mysql
tar xf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar

解压完使用yum直接安装rpm包

创建数据存放目录

mkdir -p /home/data/mysql3314

chown -R mysql:mysql /home/data/mysql3314

编写my.conf

vim /etc/my.cnf

[client]
port=3314
host=127.0.0.1

[mysqld@3314]
port = 3314
mysqlx_port=33140

expire_logs_days=30
max_binlog_size=200M
default-time-zone='+08:00'
innodb_flush_log_at_trx_commit=0
innodb_log_file_size=2GB
max_allowed_packet=256M
transaction_isolation='READ-COMMITTED'
max_connections=400




datadir = /home/data/mysql3314
socket = /home/data/mysql3314/mysql.sock
log-error = /home/data/mysql3314/error.log

slow_query_log = 1
slow_query_log_file = /home/data/mysql3314/slow.log
long_query_time=3

pid-file = /var/run/mysqld/mysqld.pid

启动mysql

systemctl  start mysqld@3314
systemctl  enable mysqld@3314

若启动失败 检查senliunx，firewalld是否关闭

获取密码

grep password /home/data/mysql3314/error.log

 登录mysql并配置root密码及权限

mysql -p

#配置新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

#授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' ;

#刷新
FLUSH PRIVILEGES;

此方式可以启动多个MySQL实例 需要配置其他实例配置文件，及数据目录