一、安装说明

1、系统：openEuler操作系统
2、版本：MySQL - 8.0.36
3、下载地址：https://dev.mysql.com/get/Downloads/MySQL-8.0

二、二进制方式安装步骤

1、下载glibc版本的Mysql

[root@node7 ~]# wget -c https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.36-linux-glibc2.28-x86_64.tar.xz
[root@node7 ~]# ll

total 448948
-rw-r--r-- 1 root root 459718996 Dec 13 22:33 mysql-8.0.36-linux-glibc2.28-x86_64.tar.xz

2、新建用户以安全方式运行进程

[root@node7 ~]# groupadd -r -g 306 mysql
[root@node7 ~]# useradd -r -u 306 -g 306 -s /bin/false mysql
[root@node7 ~]# grep mysql /etc/passwd

mysql:x:306:306::/home/mysql:/bin/false

3、安装初始化MySQL

[root@node7 ~]# tar xf mysql-8.0.36-linux-glibc2.28-x86_64.tar.xz -C /usr/local/
[root@node7 ~]# ln -s /usr/local/mysql-8.0.36-linux-glibc2.28-x86_64/ /usr/local/mysql #做软连接
[root@node7 ~]# chown -R mysql.mysql /usr/local/mysql/ #赋权，注意因为是软链接,路径最后一定要加"/"
[root@node7 ~]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data #会生成初始密码

2024-02-19T08:02:54.078047Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.36) initializing of server in progress as process 1975
2024-02-19T08:02:54.084162Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-02-19T08:02:54.425020Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-02-19T08:02:56.201652Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: `6E5*85RkK+Qr`

4、提供配置文件和服务脚本

[root@node7 ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@node7 ~]# sed -i '/^basedir=/ c basedir=/usr/local/mysql/' /etc/init.d/mysqld #指定basedir
[root@node7 ~]# sed -i '/^datadir=/ c datadir=/usr/local/mysql/data/' /etc/init.d/mysqld #指定datadir
[root@node7 ~]# chkconfig --add mysqld
[root@node7 ~]# chkconfig mysqld on
[root@node7 ~]# vim /etc/my.cnf.d/mysql-server.cnf

[mysqld]

datadir=/usr/local/mysql/data
basedir=/usr/local/mysql/
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/data/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid

5、启动服务

[root@node6 ~]# systemctl start mysqld.service
[root@node7 ~]# systemctl is-active mysqld.service
active

6、配置环境变量

[root@node6 ~]# echo 'export PATH=$PATH:/usr/local/mysql/bin/' > /etc/profile.d/mysql.sh
[root@node6 ~]# source /etc/profile.d/mysql.sh

7、修改密码并测试

[root@node7 ~]# mysqladmin -uroot -p'6E5*85RkK+Qr' password 'MySQL@123'
[root@node7 ~]# mysql -uroot -pMySQL@123 -e 'show databases;'

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+