物理机安装mysql8, 修改数据库目录

自动安装mysql ,并修改数据库目录.

#! /bin/bash
#mysql官方下载路径:https://dev.mysql.com/downloads/mysql/

# 配置dnf源
mkdir -p /etc/yum.repos.d/backup && mv /etc/yum.repos.d/*.repo /etc/yum.repos.d/backup
curl http://119.57.77.139:22538/os/x86_64/centos8.repo -o /etc/yum.repos.d/centos8.repo
dnf clean all && dnf makecache
dnf install -y mtr vim bash-completion perl telnet

#解压 & 配置数据目录
tar -xvf mysql-8.0.30-1.el8.x86_64.rpm-bundle.tar 

#安装
rpm -ivh mysql-community-common-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-client-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.30-1.el8.x86_64.rpm
rpm -ivh mysql-community-server-8.0.30-1.el8.x86_64.rpm

#初始化配置/data/mysql3306/data 
mkdir -p /data
sed -i '/.*datadir=*/c\datadir=/data/mysql' /etc/my.cnf
sed -i '/.*socket=*/c\datadir=/data/mysql/mysql.sock' /etc/my.cnf
cp -a /var/lib/mysql /data
mysqld --initialize --console
semanage fcontext -a -t mysqld_db_t /data/mysql
semanage fcontext -a -t mysqld_var_run_t '/data/mysql/mysql\.sock'
restorecon -R /data/mysql
chcon -R --reference /var/lib/mysql /data/mysql
chmod -R 777 /data/mysql

#启动
systemctl start mysqld
systemctl enable mysqld
cat /var/log/mysqld.log | grep password