在ECS上安装mysql

1.获取安装包

cd /opt

wget https://sandbox-expriment-files.obs.cn-north-1.myhuaweicloud.com:443/20220530/MySQL-5.6.45-1.el6.x86_64.rpm-bundle.tar

2.创建安装目录

mkdir mysql_install

3. 解压到安装目录

tar -xvf MySQL-5.6.45-1.el6.x86_64.rpm-bundle.tar -C mysql_install

4.进到安装目录

cd mysql_install

5.移除mariadb*

yum -y remove mariadb*

6.安装以下功能

yum install -y MySQL-shared-compat-5.6.45-1.el6.x86_64.rpm

yum install -y MySQL-server-5.6.45-1.el6.x86_64.rpm

yum install -y MySQL-client-5.6.45-1.el6.x86_64.rpm

yum install -y MySQL-devel-5.6.45-1.el6.x86_64.rpm

yum install -y MySQL-shared-5.6.45-1.el6.x86_64.rpm

7.创建配置文件 my.cnf

cat << EOF >> /etc/my.cnf
[mysqld]
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
lower_case_table_names = 1
innodb_strict_mode = 1
sql_mode =
symbolic-links=0
character_set_server = utf8
log-bin = mysql-bin
binlog_format=row
server-id = 2
expire_logs_days = 10
slave_skip_errors = 1062
innodb_strict_mode = 0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
EOF

8.启动

systemctl start mysql

9.创建修改密码的脚本 mysql_pass.sh

vim mysql_pass.sh

输入模式后，粘贴以下内容

#!/bin/bash
# 安装expect插件
yum install -y expect
# 修改密码为Huawei@123!
pass=`awk -F"[ :]+" 'NR==1{print $NF}' /root/.mysql_secret`
/bin/expect << EOF
spawn /usr/bin/mysql -h127.0.0.1 -uroot -p`echo -e $pass`
expect "mysql>"
send "SET PASSWORD FOR root@localhost=PASSWORD('Huawei@123!');"
send "\n"
expect "mysql>"
send 'flush privileges\n'
expect "mysql>"
send 'quit\n'
interact
EOF

10. 执行权限

chmod +x mysql_pass.sh

11.执行

./mysql_pass.sh

12.客户端登陆

/usr/bin/mysql -h127.0.0.1 -uroot -pHuawei@123!

13.设置数据库权限

grant all privileges on *.* to root@"%" identified by "Huawei@123!";

flush privileges;

quit;