无网络 二进制部署MySQL 8.0，适合懒人，复制粘贴即可，不需要修改任何东西

无网络 二进制部署MySQL 8.0，适合懒人，复制粘贴即可，不需要修改任何东西

1、安装依赖包

yum -y install libaio ncurses-devel openssl-devel openssl cmake mariadb-devel vim lrzsz unzip wget net-tools

2、下载

#请提前在网络环境中将包下载OK
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz

3、解压

tar xf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz -C /usr/local

4、创建mysql用户

useradd -r -M -s /sbin/nologin mysql
useradd -r -M -s /sbin/nologin -u 306 mysql

5、重新命名，创建数据存放目录

cd  /usr/local/
mv  mysql-8.0.20-linux-glibc2.12-x86_64 mysql
ln -s mysql mysql
chown -R mysql.mysql mysql*
ll -d mysql
echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
source /etc/profile.d/mysql.sh
mkdir /opt/data
chown -R mysql.mysql /opt/data
ll -d /opt/data/

6、初始化数据库，并配置

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --datadir=/opt/data
#这里加入了-insecure选项，可以不要密码

7、创建软连接，修改属主和环境变量

ln -s /usr/local/mysql/include /usr/local/include/mysql
echo '/usr/local/mysql/lib' > /etc/ld.so.conf.d/mysql.conf
ldconfig

8、生成配置文件

cat > /etc/my.cnf <<EOF
[mysqld]
basedir = /usr/local/mysql
datadir = /opt/data
socket = /tmp/mysql.sock
port = 3306
pid-file = /opt/data/mysql.pid
user = mysql
skip-name-resolve
EOF

9、配置服务启动脚本

cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
sed -ri 's#^(basedir=).*#\1/usr/local/mysql#g' /etc/init.d/mysqld
sed -ri 's#^(datadir=).*#\1/opt/data#g' /etc/init.d/mysqld

10、启动mysql，并修改密码

chkconfig mysqld on    #设置为开机自动启动
service mysqld start
ss -antl |grep 3306

11、登录MySQL设置密码

mysql -uroot 

SET PASSWORD FOR 'root'@'localhost' = 'yeshengdjlanyangyang';
flush privileges;

service mysqld stop

12、使用systemctl启动MySQL

cat >> /usr/lib/systemd/system/mysqld.service <<EOF
[Unit]
Description=MySQL8.0.20 Server 3306
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
TimeoutSec=0
PermissionsStartOnly=true
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
Restart=on-failure
RestartPreventExitStatus=1
EOF

13、重新启动，查看状态

systemctl daemon-reload
systemctl restart mysqld
systemctl status mysqld