前提：最近服务器x86架构迁移到arm（华为云6.5）架构上 由于此安装包默认安装在usr/local/目录下，自定义安装目录需要修改 以下相关/usr/local/目录， 且配置文件/etc/my.cnf相关/usr/local/目录也要修改
# 删除旧版本Mysql-libs
sudo yum remove mysql-libs
# 删除旧版本Mysql
sudo yum remove $(rpm -qa|grep -i mysql)
rm -rf $(find / -name mysql)
# 验证是否删除成功
rpm -qa|grep -i mysql && find / -name mysql
0.软件包下载地址为：obs-mirror-ftp4.obs.cn-north-4.myhuaweicloud.com/database/my…
1.添加mysql用户组和mysql用户，用于隔离mysql进程
groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -M mysql
2.安装依赖库
yum install -y libaio*
3.下载解压Mysql
wget https://obs-mirror-ftp4.obs.cn-north-4.myhuaweicloud.com/database/mysql-5.7.27-aarch64.tar.gz
# 解压
tar xvf mysql-5.7.27-aarch64.tar.gz -C /usr/local/
4.配置Mysql
mv /usr/local/mysql-5.7.27-aarch64 /usr/local/mysql
mkdir -p /usr/local/mysql/logs
chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /dev/shm
ln -sf /usr/local/mysql/my.cnf /etc/my.cnf
# 此步骤直接输入2次'y'即可
cp -rf /usr/local/mysql/extra/lib* /usr/lib64/
mv /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.6.old
ln -s /usr/lib64/libstdc++.so.6.0.24 /usr/lib64/libstdc++.so.6
5. 设置开机启动
cp -rf /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
6.添加环境变量
vim /etc/profile
# 增加以下两行
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
# 生效
source /etc/profile
7.随机密码初始化登录
# "–initialize"生成随机密码，在这里存储在/usr/local/mysql/logs/mysql-error.log
mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
8.编辑/etc/my.cnf
#去掉注释，是否对大小写敏感 1-表示不敏感
lower_case_table_names =1
#新增sql_mode设置（具体解释请百度）
sql_mode=
9.启动、停止、自启动
# 启动
systemctl start mysqld
# 停止
systemctl status mysqld
# 自启动
systemctl enable mysqld
10.查看修改随机密码、添加授权远程普通用户
cat /usr/local/mysql/logs/mysql-error.log | grep password
mysql -uroot -p
修改root密码
alter user root@localhost identified by '你的密码';
创建普通远程管理账号
create user 'eb'@'%' identified by 'eb用户密码';
3、授权
grant all privileges on *.* to eb@'%' identified by 'eb用户密码';
4、配置生效
flush privileges;
# 重启动
systemctl restart mysqld
