ARM64架构下面安装mysql5.7.22

最新推荐文章于 2025-11-13 00:09:13 发布

原创最新推荐文章于 2025-11-13 00:09:13 发布 · 2.6k 阅读

14 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #database

linux 同时被 2 个专栏收录

7 篇文章

订阅专栏

数据库

5 篇文章

订阅专栏

本文记录了在ARM64架构上安装MySQL5.7.22的详细步骤，包括下载地址、添加用户组与用户、配置、设置开机启动、环境变量设置、数据库初始化、启动验证及密码设置与远程连接配置。

原文地址

问题描述

需要在ARM64架构下面安装mysql数据库5.7.22版本，对过程进行一下记录

① MySQL5.7.22ARM64架构下载地址

https://link.zhihu.com/?target=https%3A//obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz

② 添加mysql用户组和mysql用户

# 添加mysql用户组和mysql用户，用于隔离mysql进程
[root@Pi4B ~]#  groupadd -r mysql && useradd -r -g mysql -s /sbin/nologin -M mysql
# 安装依赖库
[root@Pi4B ~]# yum install -y libaio*
# 下载解压Mysql
[root@Pi4B ~]# wget https://obs.cn-north-4.myhuaweicloud.com/obs-mirror-ftp4/database/mysql-5.7.27-aarch64.tar.gz
[root@Pi4B ~]# tar -xvf mysql-5.7.27-aarch64.tar.gz -C /usr/local/

③ 配置mysql

[root@Pi4B ~]# mv /usr/local/mysql-5.7.27-aarch64 /usr/local/mysql
[root@Pi4B ~]# mkdir -p /usr/local/mysql/logs
[root@Pi4B ~]# chown -R mysql:mysql /usr/local/mysql 
[root@Pi4B ~]# ln -sf /usr/local/mysql/my.cnf /etc/my.cnf
[root@Pi4B ~]# cp -rf /usr/local/mysql/extra/lib* /usr/lib64/ 
[root@Pi4B ~]# mv /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.6.old
[root@Pi4B ~]# ln -s /usr/lib64/libstdc++.so.6.0.24 /usr/lib64/libstdc++.so.6

④ 设置开机启动

[root@Pi4B ~]# cp -rf /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld 
[root@Pi4B ~]# chmod +x /etc/init.d/mysqld
[root@Pi4B ~]# systemctl enable mysqld

⑤ 添加环境变量

[root@Pi4B ~]# vim /etc/profile
# 在尾部添加
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
# 刷新
[root@Pi4B ~]# source /etc/profile

⑥ 初始化启动mysql

# 无密码初始化登录
[root@Pi4B ~]# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

#开启mysql
[root@Pi4B ~]# systemctl start mysqld
#查看状态
[root@Pi4B ~]# systemctl status mysqld

⑦ 到这里如果看到如下mysql状态active (running)表示mysql已经安装成功了。

● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: active (running) since Tue 2024-02-20 17:06:53 CST; 5 days ago
     Docs: man:systemd-sysv-generator(8)
   CGroup: /system.slice/mysqld.service
           ├─27500 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/mysql.pid
           └─29084 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib...

Feb 20 17:06:52 localhost.localdomain systemd[1]: Starting LSB: start and stop MySQL...
Feb 20 17:06:53 localhost.localdomain mysqld[27481]: Starting MySQL. SUCCESS!
Feb 20 17:06:53 localhost.localdomain systemd[1]: Started LSB: start and stop MySQL.

⑧ 登录mysql（这里第一次登录没有密码，直接回车即可）

mysql -u root -p

⑨ 设置密码

[root@Pi4B ~]# mysql -u root -p
mysql> use mysql;
mysql> update user set authentication_string=password("你的密码") where user="root";
mysql> flush privileges;
mysql> quit;

⑩ 设置远程连接

mysql> use mysql;
Database changed
mysql> grant all privileges  on *.* to root@'%' identified by "你的密码";
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;