二进制安装MySQL 8.0

##################################################
########## 二进制安装MySQL 8.0 ###############
##################################################
1、解压

xz -d mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz

tar xvf mysql-8.0.21-linux-glibc2.12-x86_64.tar

mv mysql-8.0.21-linux-glibc2.12-x86_64 mysql80

mv mysql80/ /usr/local/

chown -R mysql.mysql /usr/local/mysql80/

2、修改配置文件

mkdir -p /data/mysql80

chown -R mysql.mysql /data

cat > /data/mysql80/my.cnf <<EOF
[mysqld]
basedir=/usr/local/mysql80
datadir=/data/mysql80/data
socket=/tmp/mysql80.sock
user=mysql
log_error=/tmp/mysql80.log
skip_name_resolve
log_bin=/data/mysql80/mysql-bin
port=8006
server_id=8006
EOF

3、准备启动脚本

cat >/etc/systemd/system/mysqld80.service<<EOF
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql80/bin/mysqld --defaults-file=/data/mysql80/my.cnf
LimitNOFILE = 5000
EOF

4、初始化数据

/usr/local/mysql80/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql80  --datadir=/data/mysql80/data

mysqld --defaults-file=/home/mysql/mysql170200/my.cnf --initialize-insecure --user=mysql

5、启动数据库

systemctl start mysqld80

/usr/local/mysql80/bin/mysql -S /tmp/mysql80.sock