Centos7-mysql-8.0.24-rpm(aarch)编译安装

# Centos7-mysql-8.0.24-rpm(aarch)编译安装

> what：Centos7-mysql-8.0.24-rpm(aarch)

> where： centos 7.9

[mysql下载地址](https://downloads.mysql.com/archives/community/)

[官方文档](https://dev.mysql.com/doc/refman/8.0/en/source-installation-prerequisites.html)

[docker下载安装地址](http://121.36.29.32:8083/wangruiying/docker/-/blob/master/Docker%E5%9F%BA%E7%A1%80%E7%9F%A5%E8%AF%86%E5%8F%8A%E4%BD%BF%E7%94%A8/docker%E5%AE%89%E8%A3%85/docker%E5%9C%A8centos%E7%8E%AF%E5%A2%83%E4%B8%8B%E7%9A%84%E5%9F%BA%E6%9C%AC%E5%AE%89%E8%A3%85%E4%B8%8E%E4%BD%BF%E7%94%A8.md)

## 1.环境信息

```
（1）查看docker版本
[root@ecs-hk-arm ~]# docker -v
Docker version 20.10.2, build 2291f61
（2）为保证环境纯净，以镜像centos7启动docker容器
[root@ecs-hk-arm ~]# docker run -itd --name centos7-mysql8.0.24 centos:7
17ae095ca2bcf6a8fcfded7c69dc170b142bdac055731b7b192925120732907f
[root@ecs-hk-arm ~]# docker exec -it centos7-mysql8.0.24 bash
（3）查看操作系统及内核版本
[root@17ae095ca2bc /]# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (AltArch)
[root@17ae095ca2bc /]# uname -a
Linux 17ae095ca2bc 4.18.0-193.28.1.el7.aarch64 #1 SMP Wed Oct 21 16:25:35 UTC 2020 aarch64 aarch64 aarch64 GNU/Linux
```

## 2.安装依赖

```
[root@17ae095ca2bc /]# yum install -y epel-release
[root@17ae095ca2bc /]# yum install -y rpm-build make openldap-devel cyrus-sasl-devel openssl-devel numactl-devel ncurses-devel libaio-devel zlib-devel bison time perl perl-devel autoconf libaio perl-JSON.noarch perl-Env.noarch cmake3
```

## 3.gcc10.2.1安装（centos7默认版本是4.8.5）

```
[root@17ae095ca2bc installed]# yum install centos-release-scl -y
[root@17ae095ca2bc installed]# yum install devtoolset-10 -y     ##devtoolset-10对应gcc10.x.x版本
[root@17ae095ca2bc installed]# source /opt/rh/devtoolset-10/enable
[root@17ae095ca2bc installed]# gcc --version     ##查看版本是gcc10.2.1
gcc (GCC) 10.2.1 20210130 (Red Hat 10.2.1-11)
Copyright (C) 2020 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

[root@17ae095ca2bc installed]# g++ --version     ##查看版本是g++10.2.1
g++ (GCC) 10.2.1 20210130 (Red Hat 10.2.1-11)
Copyright (C) 2020 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
```

## 5.编译安装

```
（1）获取源码
[root@17ae095ca2bc installed]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-8.0.24-1.el7.src.rpm
[root@17ae095ca2bc installed]# ll
total 410264
-rw-r--r-- 1 root root 420103544 Mar 23 11:53 mysql-community-8.0.24-1.el7.src.rpm
（2）编译
[root@17ae095ca2bc installed]# rpm -ivh mysql-community-8.0.24-1.el7.src.rpm
[root@17ae095ca2bc installed]# rpmbuild -ba /root/rpmbuild/SPECS/mysql.spec
Wrote: /root/rpmbuild/SRPMS/mysql-community-8.0.24-1.el7.src.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-server-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-client-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-common-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-test-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-devel-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-libs-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-client-plugins-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-libs-compat-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-community-embedded-compat-8.0.24-1.el7.aarch64.rpm
Wrote: /root/rpmbuild/RPMS/aarch64/mysql-router-community-8.0.24-1.el7.aarch64.rpm
Executing(%clean): /bin/sh -e /var/tmp/rpm-tmp.j3ACNw
+ umask 022
+ cd /root/rpmbuild/BUILD
+ cd mysql-8.0.24
+ /usr/bin/rm -rf /root/rpmbuild/BUILDROOT/mysql-community-8.0.24-1.el7.aarch64
+ exit 0
（3）配置yum本地仓库安装mysql包
#安装createrepo
[root@17ae095ca2bc aarch64]# yum install createrepo -y
#将存放安装包的目录制作成软件仓库，命令执行成功后会在该目录下创建一个repodata目录
[root@17ae095ca2bc aarch64]# createrepo /root/rpmbuild/RPMS/aarch64
Spawning worker 0 with 2 pkgs
Spawning worker 1 with 2 pkgs
Spawning worker 2 with 1 pkgs
Spawning worker 3 with 1 pkgs
Spawning worker 4 with 1 pkgs
Spawning worker 5 with 1 pkgs
Spawning worker 6 with 1 pkgs
Spawning worker 7 with 1 pkgs
Workers Finished
Saving Primary metadata
Saving file lists metadata
Saving other metadata
Generating sqlite DBs
Sqlite DBs complete
#创建.repo配置文件指向到本地仓库的路径，注意文件名一定要是.repo结尾
[root@17ae095ca2bc installed]# cat /etc/yum.repos.d/test.repo
[test]
name=test
baseurl=file:///root/rpmbuild/RPMS/aarch64
enabled=1
gpgcheck=0
#通过yum repolist命令查看本地test仓库
[root@17ae095ca2bc installed]# yum repolist
[root@17ae095ca2bc installed]# yum clean all
[root@17ae095ca2bc installed]# yum makecache
[root@17ae095ca2bc installed]# yum list |grep 8.0.24
[root@17ae095ca2bc aarch64]# yum list |grep 8.0.24
mysql-community-client.aarch64             8.0.24-1.el7           test          
mysql-community-client-plugins.aarch64     8.0.24-1.el7           test          
mysql-community-common.aarch64             8.0.24-1.el7           test          
mysql-community-devel.aarch64              8.0.24-1.el7           test          
mysql-community-embedded-compat.aarch64    8.0.24-1.el7           test          
mysql-community-libs.aarch64               8.0.24-1.el7           test          
mysql-community-libs-compat.aarch64        8.0.24-1.el7           test          
mysql-community-server.aarch64             8.0.24-1.el7           test          
mysql-community-test.aarch64               8.0.24-1.el7           test          
mysql-router-community.aarch64             8.0.24-1.el7           test 
[root@17ae095ca2bc installed]# yum install -y mysql-community-server.aarch64
[root@17ae095ca2bc installed]# yum install -y mysql-community-client.aarch64
```

## 6.数据库配置验证

```
参考官方文档：https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html
（1）初始化数据库,初始化时不产生临时密码，使用空密码登录，参考如下链接：
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
[root@17ae095ca2bc sbin]# cd /usr/sbin/
[root@17ae095ca2bc sbin]# ./mysqld --user=mysql --initialize-insecure
[root@17ae095ca2bc sbin]# cat /var/log/mysqld.log
2021-09-02T11:30:24.724208Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.24) initializing of server in progress as process 75348
2021-09-02T11:30:24.731051Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-09-02T11:30:25.208398Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-09-02T11:30:27.047908Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
（2）mysql启动完成后登录数据库修改初始密码重新登陆
[root@17ae095ca2bc sbin]# ./mysqld --user=mysql &
[1] 75392
[root@17ae095ca2bc sbin]#  ps -ef|grep mysql
mysql      75392      15  5 11:31 pts/1    00:00:00 ./mysqld --user=mysql
root       75436      15  0 11:31 pts/1    00:00:00 grep --color=auto mysql
[root@17ae095ca2bc sbin]#  mysql -V
mysql  Ver 8.0.24 for Linux on aarch64 (MySQL Community Server - GPL)
[root@17ae095ca2bc sbin]#  mysql -V
mysql  Ver 8.0.24 for Linux on aarch64 (MySQL Community Server - GPL)
[root@17ae095ca2bc sbin]# mysql -uroot   
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.24 MySQL Community Server - GPL

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
（3）新建数据库新建简单数据表查看数据
mysql> create database test;
Query OK, 1 row affected (0.01 sec)

mysql> use test ;
Database changed
mysql> create table test1 (id int not null primary key,name varchar(10));
Query OK, 0 rows affected (0.03 sec)

mysql> insert into test1(id,name) values (1,'Tom'),(2,'Mary');
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select  * from test1;
+----+------+
| id | name |
+----+------+
|  1 | Tom  |
|  2 | Mary |
+----+------+
2 rows in set (0.00 sec)
（4）更新数据、删除数据
mysql>  update test1 set name='linda' where id=1;use test ;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Database changed
mysql> select  * from test1;
+----+-------+
| id | name  |
+----+-------+
|  1 | linda |
|  2 | Mary  |
+----+-------+
2 rows in set (0.00 sec)

mysql> delete from test1 where id=1;
Query OK, 1 row affected (0.00 sec)

mysql> select  * from test1;
+----+------+
| id | name |
+----+------+
|  2 | Mary |
+----+------+
1 row in set (0.00 sec)
```