# 创建mysql安装脚本
cat <<'EOF'> /home/sh/mysql_install.sh
#避免error while loading shared libraries: libnuma.so.1: cannot open shared object file
yum -y install numactl.x86_64
cd /home/service
tar -zxvf /home/service/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
mv /home/service/mysql-5.7.30-linux-glibc2.12-x86_64 /home/service/mysql
groupadd mysql
useradd -r -g mysql mysql
chown -R mysql:mysql /home/service/mysql
chown -R mysql:mysql /home/logs/mysql
cp -rf /home/config/mysql/my.cnf /etc/my.cnf
/home/service/mysql/bin/mysqld --initialize --user=mysql --datadir=/home/service/mysql/data --basedir=/home/service/mysql
cp /home/service/mysql/support-files/mysql.server /etc/init.d/mysql
sed -i "s/^basedir=$/basedir=\/home\/service\/mysql/g" /etc/init.d/mysql
sed -i "s/^datadir=$/datadir=\/home\/service\/mysql\/data/g" /etc/init.d/mysql
chkconfig --add mysql
chkconfig mysql on
chkconfig --level 345 mysql on
service mysql start
EOF
grep 'password' /home/logs/mysql/mysqld.log
#2020-08-31T04:56:25.142596Z 1 [Note] A temporary password is generated for root@localhost: u6whd?esl0dI
安装完成啦,如果能帮到您,多多关注哦,谢谢,点个赞呗
题外话:mysql 停止,启动,重启
service stop mysql
service start mysql
service restart mysql
题外话:mysql 登录
mysql -u root -p
# 或者
/home/service/mysql/bin/mysql -u root -p
题外话:修改mysql 初始密码
SET PASSWORD = PASSWORD('123123');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
flush privileges;
或者
ALTER USER 'root'@'%' IDENTIFIED BY '123456';
flush privileges;
set password for root@localhost = password('123123');
flush privileges;
题外话:修改mysql授权IP登录
update user set host = '%' where user ='root';
flush privileges;