鲲鹏CPU+麒麟操作系统arm环境安装MySQL

系统环境背景：

CPU：鲲鹏920

操作系统：Ky10 SP3

MySQL版本：8.4.2

一、下载MySQL

官网地址：https://downloads.mysql.com/archives/community/

二：MySQL安装前准备

2.1关闭防火墙

[root@ky-b ~]# systemctl stop firewalld
[root@ky-b ~]# systemctl disable firewalld
Removed /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@ky-b ~]# setenforce 0
setenforce: SELinux is disabled
[root@ky-b ~]# sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

2.2卸载boot与系统自带的MySQL

[root@ky-b ~]#  systemctl stop mariadb
[root@ky-b ~]#  yum -y remove mysql*
[root@ky-b ~]#  yum -y remove mariadb*
[root@ky-b ~]#  yum -y remove boost-*
[root@ky-b ~]#  rm -rf /var/lib/mysql
[root@ky-b ~]#  rm -rf /etc/my.cnf

2.3安装MySQL依赖包

[root@ky-b ~]#  yum install -y cmake make gcc gcc-c++ bison ncurses ncurses-devel

三：MySQL安装

3.1上传安装包并解压

[root@ky-b ~]# tar -xf mysql-8.4.2-linux-glibc2.28-aarch64.tar.xz  -C /data/
[root@ky-b ~]# mv /data/mysql-8.4.2-linux-glibc2.28-aarch64/ /data/mysql

3.2添加组和用户

[root@ky-b ~]# groupadd mysql
[root@ky-b ~]# useradd -r -g mysql -s /bin/false mysql

3.3创建data文件夹

[root@ky-b ~]# mkdir data

3.4赋予权限

[root@ky-b ~]# chown -R mysql:mysql /data/mysql/

3.5初始化MySQL

[root@ky-b ~]# cd /data/mysql/
[root@ky-b mysql]# ./bin/mysqld --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data --initialize-insecure --user=mysql
2025-04-24T08:38:32.047412Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2025-04-24T08:38:32.078050Z 0 [System] [MY-013169] [Server] /data/mysql/bin/mysqld (mysqld 8.4.2) initializing of server in progress as process 71988
2025-04-24T08:38:32.359859Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-24T08:38:37.707625Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-24T08:38:54.837285Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2025-04-24T08:39:15.826729Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
[root@ky-b mysql]# echo $?
0

3.6修改配置文件

[root@ky-b mysql]# vim /etc/my.ini
[mysqld]
# 设置3306端口
port=3306
# 设置mysql的安装目录
basedir=/data/mysql
# 设置mysql数据库的数据的存放目录
datadir=/data/mysql/data
socket=/data/mysql/mysql.sock
# 允许最大连接数
max_connections=200
# 允许连接失败的次数。
max_connect_errors=10
# 服务端使用的字符集默认为utf8mb4
character-set-server=utf8mb4
# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB
[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4
[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
socket=/data/mysql/mysql.sock
default-character-set=utf8mb4

3.7编辑mysqld文件

[root@ky-b mysql]# cp ./support-files/mysql.server /etc/init.d/mysqld
[root@ky-b mysql]# vim /etc/init.d/mysqld
//省略
basedir=/data/mysql
datadir=/data/mysql/data
//省略

3.8设置环境变量

[root@ky-b mysql]# vim /etc/profile
export PATH=$PATH:/data/mysql/bin
[root@ky-b mysql]# source /etc/profile

3.9将MySQL添加为系统服务

[root@ky-b mysql]# chkconfig --add mysqld
[root@ky-b mysql]# chkconfig mysqld on 

启动服务测试

[root@ky-b mysql]# systemctl start mysqld

3.10修改MySQL的密码

[root@ky-b mysql]# mysqladmin -u root password 888888
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety

自此全部安装结束，撒花~~~