一、openEuler 二進制方式安裝MySQL 8.0.x

1、獲取軟件包

[root@Localhost ~]# wget -c https://mirrors.aliyun.com/mysql/MySQL-8.0/mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz

2、創建用戶和組

[root@Localhost ~]# groupadd -g 27 -r mysql
[root@Localhost ~]# useradd -u 27 -g 27 -c 'MySQL Server' -r -s /sbin/nologin mysql

3、解壓軟件包

[root@Localhost ~]# tar xf mysql-8.0.28-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

4、創建指向安裝目錄的軟連接

[root@Localhost ~]# ln -sv /usr/local/mysql-8.0.28-linux-glibc2.12-x86_64/ /usr/local/mysql
'/usr/local/mysql' -> '/usr/local/mysql-8.0.28-linux-glibc2.12-x86_64/'

5、初始化MySQL服務器

[root@Localhost ~]# cd /usr/local/mysql
[root@Localhost mysql]# mkdir mysql-files
[root@Localhost mysql]# chown mysql:mysql mysql-files
[root@Localhost mysql]# chmod 750 mysql-files
[root@Localhost mysql]# bin/mysqld --initialize --user=mysql
[root@Localhost mysql]# bin/mysql_ssl_rsa_setup
[root@Localhost mysql]# bin/mysqld_safe --user=mysql

6、配置環境變量

[root@Localhost mysql]# vim /etc/profile.d/mysql.sh
[root@Localhost mysql]# more /etc/profile.d/mysql.sh
export PATH=$PATH:/usr/local/mysql/bin/[root@Localhost mysql]# source /etc/profile.d/mysql.sh
[root@Localhost mysql]# yum install ncurses-compat-libs

7、登錄并修改密碼

[root@Localhost mysql]# mysql
mysql> alter user root@localhost identified by 'MySQL@123';
Query OK, 0 rows affected (0.01 sec)

8、提供服務腳本

[root@Localhost mysql]# mysqladmin -uroot -p'MySQL@123' shutdown
[root@Localhost mysql]# cp support-files/mysql.server /etc/init.d/mysqld
[root@Localhost mysql]# chkconfig --add mysqld

9、提供配置文件

[root@Localhost mysql]# scp /etc/my.cnf 192.168.190.144:/etc/
[root@Localhost mysql]# scp -r /etc/my.cnf.d/ 192.168.190.144:/etc/[root@Localhost mysql]# vim /etc/my.cnf
#在/etc/my.cnf中添加以下內容
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/
socket=/tmp/mysql.socklog-error=/usr/local/mysql/data/mysqld.log
pid-file=/usr/local/mysql/data/mysqld.pid

二、備份數據庫

1、備份數據庫school到/backup目錄

[root@Localhost backup]# mysqldump --opt -B school > school.sql
[root@Localhost backup]# ll
total 0
-rw-r--r--. 1 root root 0 Feb 19 18:10 school.sql

2、備份MySQL數據庫為帶刪除表的格式，能夠讓該備份覆蓋已有數據庫而不需要手動刪除原有數據庫

[root@Localhost backup]# mysqldump -uroot -p --add-drop-table school > /backup/school.sql

3、直接將MySQL數據庫壓縮備份

[root@Localhost backup]# mysqldump -uroot -p school | gzip > school_2.sql.gz
Enter password:
[root@Localhost backup]# ll
total 8
-rw-r--r--. 1 root root  941 Feb 19 18:45 school_2.sql.gz
-rw-r--r--. 1 root root 2226 Feb 19 18:34 school.sql