centos7下采用二进制方式安装mysql8

1、下载二进制安装文件，并解压至/usr/local/mysql-8.0.17，创建相关目录及文件

tar -zxf mysql-8.0.17-el7-x86_64.tar.gz -C /usr/local
mv /usr/local/mysql-8.0.17-el7-x86_64.tar.gz /usr/local/mysql-8.0.17
mkdir -p /opt/datas/mysql/data
mkdir -p /opt/datas/mysql/log

mkdir /usr/local/mysql-8.0.17/conf
touch /usr/local/mysql-8.0.17/conf/my.cnf

2、修改my.cnf文件

[mysqld]
port=3306
datadir=/opt/datas/mysql/data
log-error=/opt/datas/mysql/log/mysqld.log
user=mysql

[client]
socket=/opt/datas/mysql/mysql.socket

3、添加mysql用户，及添加相应的目录权限

groupadd mysql
useradd -s /sbin/nologin -M -g mysql mysql 
chown -R mysql:mysql /usr/local/mysql-8.0.17
echo "" > /opt/datas/mysql/log/mysqld.log
chown -R mysql:mysql /opt/datas/mysql

4、将mysql的bin目录添加到环境变量中

echo "export PATH=$PATH:/usr/local/mysql-8.0.17/bin" >> /etc/profile
source /etc/profile

5、初始化mysql

mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql-8.0.17 --datadir=/opt/datas/mysql/data

6、启用mysql

mysqld_safe --defaults-file=/usr/local/mysql-8.0.17/conf/my.cnf &

7、设置root密码

use mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
update user set host ='%' where user='root';
flush prileges;

8、关闭mysql

mysqladmin shutdown

9、添加mysql服务及设置自启动

添加文件 vim /etc/systemd/system/mysqld.service

[Unit]
Description=MySQL Server 8.0.17
After=network.target
After=syslog.target

[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql-8.0.17/bin/mysqld --defaults-file=/usr/local/mysql-8.0.17/conf/my.cnf
LimitNOFILE = 5000

开启自启动

systemctl enable mysqld

启动服务

systemctl start mysqld

10、更改防火墙设置,允许mysql远程访问

firewall-cmd --zone=public --add-port=3306/tcp --permanent
firewall-cmd --reload