3. 安装arrach结构的Mysql

提示：arm的centos上面安装arrach结构的Mysql

前言

提示：这里可以添加本文要记录的大概内容：

例如：随着人工智能的不断发展，机器学习这门技术也越来越重要，很多人都开启了学习机器学习，本文就介绍了机器学习的基础内容。

提示：以下是本篇文章正文内容，下面案例可供参考

一、查看已经安装过的并卸载mysql

如果没安装过，可以省略这个步骤

rpm -qa | grep mysql
rpm -e --nodeps mysql-community-libs-8.0.30-1.el7.aarch64
rpm -e --nodeps mysql-community-server-8.0.30-1.el7.aarch64
rpm -e --nodeps mysql-community-client-8.0.30-1.el7.aarch64
rpm -e --nodeps mysql-community-devel-8.0.25-1.el7.aarch64
rpm -e --nodeps mysql-community-client-plugins-8.0.30-1.el7.aarch64
rpm -e --nodeps mysql-community-libs-compat-8.0.30-1.el7.aarch64
rpm -e --nodeps mysql-community-common-8.0.30-1.el7.aarch64
rpm -e --nodeps mysql-community-icu-data-files-8.0.30-1.el7.aarch64

二、创建mysql用户组

mysql80需要mysql用户组

1.设置用户组

mkdir -p /var/data
mkdir -p /usr/local/mysql/data
chown -R mysql:mysql /var/data
chmod -R 755 /usr/local/mysql/data

2. 安装

前提，下载好了rpm安装包

yum install -y libaio
rpm -qa | grep mariadb
yum -y remove mariadb*
rpm -Uvh *.rpm --nodeps --force

3.设置启动

chown -R mysql:mysql /var/lib/
systemctl start mysqld
ps -ef | grep mysqld
systemctl enable mysqld
systemctl status mysqld

4.查看密码

cat /var/log/mysqld.log | grep password | head -1 | rev  | cut -d ' ' -f 1 | rev
# MYSQL_PASSWD=`cat /var/log/mysqld.log | grep password | head -1 | rev  | cut -d ' ' -f 1 | rev`

5.修改登录密码

alter user 'root'@'localhost' identified by "Qaz123456!";

6.授权

CREATE USER 'root'@'%' IDENTIFIED BY 'Qaz123456!';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
flush privileges;

7.修改连接

select host,user,plugin from mysql.user;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Qaz123456!';

8.设置参数

echo 'server_id=2' >> /etc/my.cnf
echo 'log_bin=mysql-bin' >> /etc/my.cnf
echo 'binlog_format=ROW' >> /etc/my.cnf
echo 'expire_logs_days=30' >> /etc/my.cnf
echo 'event_scheduler=ON' >> /etc/my.cnf

echo 'sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES' >> /etc/my.cnf
echo 'skip_ssl' >> /etc/my.cnf

重启下

systemctl restart mysqld

常见问题排查

1. 启动失败查看：

mysql centos7安装启动失败报错

2. 用户操作

1、创建用户
useradd mysql
passwd mysql
2、修改用户
userdel mysql
groupdel mysql
groupadd mysql
useradd -g mysql mysql

3. 踩坑解决

报错


解决

chown -R mysql:mysql /var/lib/
systemctl start mysqld
cat /var/log/mysqld.log
ps -ef | grep mysql 
systemctl status mysqld

Mysql-AARCH64平台安装遇到问题解决

没权限问题解决

rm -rf /var/lib/