自建mysql8.0脚本

对Gcc版本要求有一点点高,注意升级版本

脚本

#!/bin/bash
#对gcc版本要求过高，用得是鲲鹏openEuler镜像
echo "安装make依赖"
yum -y install gcc gcc-c++ automake zlib zlib-devel bzip2 bzip2-devel bzip2-libs readline readline-devel bison ncurses ncurses-devel libaio-devel openssl openssl-devel gmp gmp-devel mpfr mpfr-devel libmpc libmpc-devel bison* ncurses* libtirpc libtirpc-devel ncurses-devel rpcgen 
echo "配置MySQL安装环境"
echo "1、关闭SELinux"
setenforce 0

echo "创建mysql用户并设置密码&&自动输入密码的脚本"
yum -y install expect
groupadd mysql
useradd -g mysql mysql
password=123Asd
cat << EOF >> mysql.sh
#!/usr/bin/expect 
set timeout 10
spawn passwd mysql
expect "New password:"
send "$password\r"
send "\n"
expect "Retype new password:"
send "$password\r"
interact
EOF

chmod +x mysql.sh
expect mysql.sh


echo "创建数据盘"
mkdir /data
mkdir -p /data/mysql
cd /data/mysql
mkdir data tmp run log
chown -R mysql:mysql /data/mysql

echo "安装MySQL"

wget wget https://mirrors.nju.edu.cn/openeuler/openEuler-20.03-LTS/everything/aarch64/Packages/mysql-8.0.17-3.oe1.aarch64.rpm
wget https://mirrors.nju.edu.cn/openeuler/openEuler-20.03-LTS/everything/aarch64/Packages/libatomic-7.3.0-20190804.h31.oe1.aarch64.rpm
rpm -ivh *.rpm

echo "运行MySQL"
echo "1、编辑my.cnf文件"

cat << EOF >> /etc/my.cnf
[mysqld_safe]
log-error=/data/mysql/log/mysql.log
pid-file=/data/mysql/run/mysqld.pid
[mysqldump]
quick
[mysql]
no-auto-rehash
[client]
port=3307
user=mysql
default-character-set=utf8
[mysqld]
basedir=/usr/local/mysql
socket=/data/mysql/data/mysql.sock
tmpdir=/data/mysql/tmp
datadir=/data/mysql/data
default_authentication_plugin=mysql_native_password
EOF
echo "2、修改配置文件/etc/my.cnf 的用户组和用户权限为 mysql:mysql"
chown mysql:mysql /etc/my.cnf
ll /etc/my.cnf

echo "3、MySQL 加入 service 服务"
chmod 777 /usr/local/mysql/support-files/mysql.server
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
echp "4、修改/etc/init.d/mysql 的用户组和用户权限为 mysql:mysql"
chown -R mysql:mysql /etc/init.d/mysql
ll /etc/init.d/mysql
echo "5、编辑/etc/profile 文件" 
sed -i -e '$a # \nexport MYSQL_HOME=/usr/local/mysql \nexport PATH=$MYSQL_HOME/bin:$PATH' /etc/profile
echo "6、执行 source 命令，重新加载环境变量"
source /etc/profile
echo "7、修改/data/mysql/和/usr/local/mysql 的用户组和用户权限为 mysql:mysql，并赋予当前用户/data 目录下的读写权限"
chown -R mysql:mysql /data/mysql/
chown -R mysql:mysql /usr/local/mysql
chmod 777 /data

#初始化数据库
sudo -u mysql /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize
#启动数据库
sudo -u mysql service mysql start

#########################################################################################

#登录数据库
#sudo -u mysql /usr/local/mysql/bin/mysql -uroot -p -S /data/mysql/data/mysql.sock
#配置数据库帐号密码
#alter user 'root'@'localhost' identified by '01271916Tao@'; #修改root本地登录账号密码
#创建远程操作账户&&进行远程访问的授权&&更新权限(做迁移时8.0版本，用户权限源库不能大于目标库，这里不做权限设置)
#create user 'root'@'%' identified with mysql_native_password by '123Asd@';
#grant all privileges on *.* to 'root'@'%' with grant option;（视情况）
#flush privileges;