MySQL安装
下面的安装步骤适用于mysql5.7,mysql8的my.cnf的参数设置略有不同,并且需要先设置好my.cnf再初始化数据库。
#!/bin/bash
#rz mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz mysql_v1.2.sh in /usr/local/src
yum install -y libaio-devel net-tools initscripts numactl
echo '2.屏蔽当前的MySQL环境'
pid=`netstat -lntup|grep 52102|awk -F "[ ]+|/" '{print$7}'`
kill -9 $pid
\mv /etc/my.cnf /etc/my.cnf`date +%Y%m%d%H时%M分%S`
\mv /usr/local/mysql /usr/local/mysql`date +%Y%m%d%H时%M分%S`
service mysql stop
systemctl stop mysql
echo '3.检查并卸载系统中低版本的mysql'
rpm -e mariadb-libs --nodeps
echo '4.添加用户和组'
#rm -rf /home/mysql/
userdel mysql
#groupdel mysql
groupadd mysql
useradd -g mysql mysql
echo '5.创建目录及授权'
\mv /data/mysqldata /data/mysqldata`date +%Y%m%d%H时%M分%S`
#mkdir -p /data/mysql/data
#mkdir -p /data/binlog
#mkdir -p /data/backup
mkdir -p /data/mysqldata
chown -R mysql:mysql /data/mysqldata
#chown -R mysql:mysql /usr/local/mysql
#chown -R mysql. /data/
#chown -R mysql. /data/mysql/data
#chown -R mysql. /data/binlog
#chown -R mysql. /data/backup
echo '6.上传解包软件包'
cd /usr/local/src/
[ -d "mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz" ] || tar zxf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz && echo 'file exists!'
mv mysql-5.7.32-linux-glibc2.12-x86_64 /usr/local/mysql
chown -R mysql. /usr/local/mysql
echo '7.修改系统环境变量'
echo "export PATH=/usr/local/mysql/bin:$PATH" >> /etc/profile
source /etc/profile
echo '8.安装mysql依赖'
#cd /yl
#rpm -ivh --force mysql*.rpm
echo '9.初始化数据'
cd
/usr/local/mysql/bin/mysqld --initialize-insecure --user<