openEuler二进制安装MySQL8.0.x

一、环境准备

1、系统：openEuler操作系统

2、MySQL版本：MySQL-8.0.36

3、下载地址：https://dev.mysql.com/get/Downloads/MySQL-8.0

二、安装步骤

1、下载glibc版本的MySQL

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

[root@node4 ~]# groupadd -r -g 306 mysql
[root@node4 ~]# useradd -r -u 306 -g 306 -s /bin/false mysql

3、安装初始化MySQL

[root@node4 ~]# tar xf mysql-8.0.36-linux-glibc2.28-x86_64.tar.xz -C /usr/local/
[root@node4 ~]# ln -s /usr/local/mysql-8.0.36-linux-glibc2.28-x86_64/ /usr/local/mysql
[root@node4 ~]# chown -R mysql.mysql /usr/local/mysql/ 
[root@node4 ~]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

2024-02-20T08:02:56.201652Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: `ff-USV%Hv4p%`

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

[root@node4 ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

[root@node4 ~]# chkconfig --add mysqld

[root@node4 ~]# chkconfig mysqld on

[root@node4 ~]# 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 ~]# echo 'export PATH=$PATH:/usr/local/mysql/bin/' > /etc/profile.d/mysql.sh [root@node6 ~]# source /etc/profile.d/mysql.sh

6、重启并修改密码

[root@node4 ~]# systemctl restart mysqld

[root@node4 ~]# mysql -uroot -p

Enter password:ff-USV%Hv4p%

mysql> alter user root@localhost identified by '1234';

Query OK, 0 rows affected (0.00 sec)

mysql> \q

Bye