麒麟服務(wù)器系統(tǒng)安裝mysql-5.7

1. 基礎(chǔ)環(huán)境

• 系統(tǒng)版本：

############## NeoKylin Linux Version#################
Release:
NeoKylin Linux Advanced Server release V7Update6 (Chromium)

Kernel:
3.10.0-957.el7.x86_64

Build:
NeoKylin Linux Advanced Server
release V7Update6/(Chromium)-x86_64
b4.lic/20190820

#################################################

• MySQL版本

[root@localhost ~]# rpm -qa | grep mysql
mysql-community-server-5.7.40-1.el7.x86_64
mysql-community-client-5.7.40-1.el7.x86_64
mysql80-community-release-el7-7.noarch
mysql-community-common-5.7.40-1.el7.x86_64
mysql-community-libs-5.7.40-1.el7.x86_64

2. 移除系統(tǒng)自帶MariaDB

[root@localhost ~]# yum remove mariadb*

3. 安裝MySQL 5.7

因?yàn)橹袠?biāo)麒麟 V7.6 系統(tǒng)源中并沒有MySQL，所以我們需要手動(dòng)添加MySQL的倉庫源。好在MySQL官方為我們提供了MySQL的倉庫源，所以我們直接使用就好了。

• 從MySQL官網(wǎng)下載倉庫源安裝包

wget https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm

• 安裝MySQL倉庫源安裝包

rpm -ivh mysql80-community-release-el7-7.noarch.rpm

• 查看MySQL倉庫源啟用情況

[root@localhost ~]# yum repolist all | grep mysql
mysql-cluster-7.5-community/x86_64           MySQL Cluster 7.5 Comm 禁用
mysql-cluster-7.5-community-source           MySQL Cluster 7.5 Comm 禁用
mysql-cluster-7.6-community/x86_64           MySQL Cluster 7.6 Comm 禁用
mysql-cluster-7.6-community-source           MySQL Cluster 7.6 Comm 禁用
mysql-cluster-8.0-community/x86_64           MySQL Cluster 8.0 Comm 禁用
mysql-cluster-8.0-community-debuginfo/x86_64 MySQL Cluster 8.0 Comm 禁用
mysql-cluster-8.0-community-source           MySQL Cluster 8.0 Comm 禁用
mysql-connectors-community/x86_64            MySQL Connectors Commu 啟用:    206
mysql-connectors-community-debuginfo/x86_64  MySQL Connectors Commu 禁用
mysql-connectors-community-source            MySQL Connectors Commu 禁用
mysql-tools-community/x86_64                 MySQL Tools Community  啟用:     94
mysql-tools-community-debuginfo/x86_64       MySQL Tools Community  禁用
mysql-tools-community-source                 MySQL Tools Community  禁用
mysql-tools-preview/x86_64                   MySQL Tools Preview    禁用
mysql-tools-preview-source                   MySQL Tools Preview -  禁用
mysql57-community/x86_64                     MySQL 5.7 Community Se 禁用
mysql57-community-source                     MySQL 5.7 Community Se 禁用
mysql80-community/x86_64                     MySQL 8.0 Community Se 啟用:    367
mysql80-community-debuginfo/x86_64           MySQL 8.0 Community Se 禁用
mysql80-community-source                     MySQL 8.0 Community Se 禁用

這里可以看到默認(rèn)啟用的是mysql 8.0的倉庫源。因?yàn)槲覀円惭bmysql 5.7，所以我們要禁用mysql 8.0的倉庫源，啟用mysql 5.7的倉庫源。

• 啟用MySQL 5.7的倉庫源

[root@localhost ~]# yum-config-manager --disable mysql80-community
[root@localhost ~]# yum-config-manager --enable mysql57-community
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]#
[root@localhost ~]# yum repolist all | grep mysql
mysql-cluster-7.5-community/x86_64           MySQL Cluster 7.5 Comm 禁用
mysql-cluster-7.5-community-source           MySQL Cluster 7.5 Comm 禁用
mysql-cluster-7.6-community/x86_64           MySQL Cluster 7.6 Comm 禁用
mysql-cluster-7.6-community-source           MySQL Cluster 7.6 Comm 禁用
mysql-cluster-8.0-community/x86_64           MySQL Cluster 8.0 Comm 禁用
mysql-cluster-8.0-community-debuginfo/x86_64 MySQL Cluster 8.0 Comm 禁用
mysql-cluster-8.0-community-source           MySQL Cluster 8.0 Comm 禁用
mysql-connectors-community/x86_64            MySQL Connectors Commu 啟用:    206
mysql-connectors-community-debuginfo/x86_64  MySQL Connectors Commu 禁用
mysql-connectors-community-source            MySQL Connectors Commu 禁用
mysql-tools-community/x86_64                 MySQL Tools Community  啟用:     94
mysql-tools-community-debuginfo/x86_64       MySQL Tools Community  禁用
mysql-tools-community-source                 MySQL Tools Community  禁用
mysql-tools-preview/x86_64                   MySQL Tools Preview    禁用
mysql-tools-preview-source                   MySQL Tools Preview -  禁用
mysql57-community/x86_64                     MySQL 5.7 Community Se 啟用:    624
mysql57-community-source                     MySQL 5.7 Community Se 禁用
mysql80-community/x86_64                     MySQL 8.0 Community Se 禁用
mysql80-community-debuginfo/x86_64           MySQL 8.0 Community Se 禁用
mysql80-community-source                     MySQL 8.0 Community Se 禁用

再次查看，我們發(fā)現(xiàn)mysql 5.7的倉庫源已經(jīng)啟用了。這里我們也可以選擇手動(dòng)編輯 /etc/yum.repos.d/mysql-community.repo ，來啟用 mysql 5.7的倉庫源。方法就是將文件中 mysql80-community enabled選項(xiàng)設(shè)置為0，將mysql57-community enabled選項(xiàng)設(shè)置為1。

• 安裝mysql 5.7

[root@localhost ~]# yum install mysql-community-server

#安裝完成之后，查看安裝情況
[root@localhost ~]# rpm -qa | grep mysql
mysql-community-server-5.7.40-1.el7.x86_64
mysql-community-client-5.7.40-1.el7.x86_64
mysql80-community-release-el7-7.noarch
mysql-community-common-5.7.40-1.el7.x86_64
mysql-community-libs-5.7.40-1.el7.x86_64

4. 初始化MySQL

• 啟動(dòng)mysql

[root@localhost ~]# systemctl start mysqld

• 設(shè)置mysql開機(jī)自啟動(dòng)

[root@localhost ~]# systemctl enable mysqld

• 查看mysql服務(wù)狀態(tài)

[root@localhost ~]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since 四 2022-11-10 14:21:09 CST; 838ms ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 16055 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 15960 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 16058 (mysqld)
    Tasks: 27
   CGroup: /system.slice/mysqld.service
           └─16058 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

11月 10 14:21:04 localhost.localdomain systemd[1]: Starting MySQL Server...
11月 10 14:21:09 localhost.localdomain systemd[1]: Started MySQL Server.
[root@localhost ~]#
[root@localhost ~]#

• 修改mysql root用戶密碼

mysql安裝成功之后會(huì)為root賬戶生成一個(gè)臨時(shí)隨機(jī)密碼，這個(gè)臨時(shí)隨機(jī)密碼我們可以在/var/log/mysqld.log文件中找到。

[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log
2022-11-10T06:21:06.369797Z 1 [Note] A temporary password is generated for root@localhost: 9eh*<Duo*yyA

知道臨時(shí)隨機(jī)密碼后，我們就可以登錄mysql，將root賬戶的密碼設(shè)置成任何我們想要的密碼了。

[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.40

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

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> 

因?yàn)閙ysql的密碼規(guī)則需要很復(fù)雜，這里我們想把密碼設(shè)置得簡單一些，所以我們需要修改一下mysql的密碼規(guī)則。這一步大家可以根據(jù)現(xiàn)場情況自行決定是否修改。

mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;

接下來將root賬戶的密碼設(shè)置成我們想要的。

ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpassword';

至此，mysql安裝完畢，你可以根據(jù)自己的需求使用mysql數(shù)據(jù)庫了。

5. 參考資料

A Quick Guide to Using the MySQL Yum Repository
centos7 安裝 Mysql 5.7.28，詳細(xì)完整教程文章來源地址http://www.zghlxwxcb.cn/news/detail-442489.html

到了這里，關(guān)于麒麟服務(wù)器系統(tǒng)安裝mysql-5.7的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！