银河麒麟V10(ARM) 离线安装 MySQL
参考教程：
https://www.cnblogs.com/liuweida/p/17105179.html
https://www.cnblogs.com/wshisboy/p/16374015.html
1. MySQL 8.0.29版本下载
直接官网下载：
https://dev.mysql.com/downloads/mysql/
选择版本：
2. 安装MySQL
2.1 删除原有的mariadb
先查看一下是否已经安装了
rpm -qa | grep mysql
rpm -qa | grep mariadbrpm -e --nodeps mariadb-libs
rpm -e mariadb-server --nodeps
yum -y remove mysql*
yum -y remove mariadb*
删除mariadb，命令：
rpm -e --nodeps mariadb-libs
rpm -e mariadb-server --nodeps
2.2 解压缩mysql离线安装包
[root@localhost MYSQL安装包]# tar xvf mysql-8.1.0-1.el8.aarch64.rpm-bundle.tar
逐个安装，命令如下：
必须安装
[root@localhost MYSQL安装包]# rpm -ivh mysql-community-common-8.1.0-1.el8.aarch64.rpm
[root@localhost MYSQL安装包]# rpm -ivh mysql-community-client-plugins-8.1.0-1.el8.aarch64.rpm
[root@localhost MYSQL安装包]# rpm -ivh mysql-community-libs-8.1.0-1.el8.aarch64.rpm
[root@localhost MYSQL安装包]# rpm -ivh mysql-community-client-8.1.0-1.el8.aarch64.rpm
[root@localhost MYSQL安装包]# rpm -ivh mysql-community-icu-data-files-8.1.0-1.el8.aarch64.rpm
[root@localhost MYSQL安装包]# rpm -ivh mysql-community-server-8.1.0-1.el8.aarch64.rpm
[root@localhost MYSQL安装包]# rpm -ivh mysql-community-devel-8.1.0-1.el8.aarch64.rpm
查看mysql
[root@localhost MYSQL安装包]# rpm -qa |grep mysql
mysql-community-client-8.1.0-1.el8.aarch64
mysql-community-server-8.1.0-1.el8.aarch64
mysql-community-client-plugins-8.1.0-1.el8.aarch64
mysql-community-icu-data-files-8.1.0-1.el8.aarch64
mysql-community-common-8.1.0-1.el8.aarch64
mysql-community-devel-8.1.0-1.el8.aarch64
mysql-community-libs-8.1.0-1.el8.aarch64
3. 初始化mysql服务
3.1 查看服务状态
命令：
[root@localhost MYSQL安装包]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor pres>
Active: inactive (dead)
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
接下来要启动MySQL，通过执行以下命令启动：
[root@localhost MYSQL安装包]# systemctl start mysqld
启动过程并不会返回任何信息即为成功。
再次查询状态
[root@localhost MYSQL安装包]# systemctl status mysqld
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor pres>
Active: active (running) since Mon 2023-07-31 14:52:26 CST; 11s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 9165 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0>
Main PID: 9242 (mysqld)
Status: "Server is operational"
Tasks: 38
Memory: 596.7M
CGroup: /system.slice/mysqld.service
└─9242 /usr/sbin/mysqld
激活状态Active显示为active，则表示启动成功。
3.2 配置MySQL
MySQL安装完成后需要对MySQL做基础配置，包括首次登录修改用户密码、数据文件位置调整、redo log大小与数量调整、undo 表空间调整、ibdata表空间调整、binlog+errorlog+slowlog+pid+socket等文件调整、性能参数调整，这些调整都可以通过修改my.cnf参数文件实现。
在MySQL安装完成第一次启动MySQL服务后，会自动为MySQL的root用户生成一个随机初始化密码，并在MySQL的errorlog文件中记录下来，我们要找到它并用它登录MySQL，修改root用户密码后才能执行任何其它操作：
- 找到初始化密码
[root@localhost MYSQL安装包]# grep password /var/log/mysqld.log
2023-07-31T06:52:18.907755Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: #SL7tAyY5ih)
SL7tAyY5ih)即为初始化密码，注意是冒号后面的所有字符都是密码
- 使用上面的初始化密码登录MySQL
[root@localhost MYSQL安装包]# mysql -uroot -p
- 修改root密码
使用初始化密码登录MySQL后只能执行修改密码的操作，其他任何操作都是不可能的，使用以下命令修改密码：
mysql> alter user user() identified by 'LaoGeDB123!';
Query OK, 0 rows affected (0.02 sec)
密码修改成功后，执行以下命令查看MySQL基本信息：
mysql> status
--------------
mysql Ver 8.1.0 for Linux on aarch64 (MySQL Community Server - GPL)
Connection id: 12
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.1.0
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/lib/mysql/mysql.sock
Binary data as: Hexadecimal
Uptime: 25 min 43 sec
Threads: 2 Questions: 10 Slow queries: 0 Opens: 130 Flush tables: 3 Open tables: 46 Queries per second avg: 0.006
--------------
- 授权远程连接
查看当前权限
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql;
mysql> select host,user,plugin from user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
| localhost | root | caching_sha2_password |
+-----------+------------------+-----------------------+
4 rows in set (0.00 sec)
授权远程访问
mysql> update user set host="%" where user='root';
mysql> select host,user,plugin from user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| % | root | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
+-----------+------------------+-----------------------+
4 rows in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)