安裝mysql數據庫及問題解決辦法

2024-07-24 12:31:57

字體：大中小

來源：轉載

供稿：網友

  安裝mysql數據庫及問題解決方法：

1、mysql官網下載安裝包

[root@seiang software]# ll

total 580020

-rw-r--r--. 1 root root 593940480 Mar 25 18:57 mysql-5.7.21-1.el7.x86_64.rpm-bundle.tar

2、解壓

[root@seiang software]# tar xvf mysql-5.7.21-1.el7.x86_64.rpm-bundle.tar

mysql-community-embedded-devel-5.7.21-1.el7.x86_64.rpm

mysql-community-minimal-debuginfo-5.7.21-1.el7.x86_64.rpm

mysql-community-common-5.7.21-1.el7.x86_64.rpm

3、全部安裝，出現如下的報錯

[root@seiang software]# rpm -ivh *.rpm

warning: mysql-community-client-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

4、如上的報錯，由于centos 7默認是mariadb數據庫，再去安裝mysql之前要先下載mariadb

[root@seiang software]# rpm -qa | grep mariadb

mariadb-libs-5.5.41-2.el7_0.x86_64

由于存在依賴關系，強制卸載

[root@seiang software]# rpm -e --nodeps mariadb-libs-5.5.41-2.el7_0.x86_64

5、安裝mysql-server，出現報錯

[root@seiang software]# rpm -ivh mysql-community-server-5.7.21-1.el7.x86_64.rpm

warning: mysql-community-server-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

6、根據提示，要先安裝mysql-community-common和mysql-community-client包

[root@seiang software]# rpm -ivh mysql-community-common-5.7.21-1.el7.x86_64.rpm

7、安裝mysql-client包，出現如下的報錯

[root@seiang software]# rpm -ivh mysql-community-client-5.7.21-1.el7.x86_64.rpm

warning: mysql-community-client-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

        mysql-community-libs(x86-64) >= 5.7.9 is needed by mysql-community-client-5.7.21-1.el7.x86_64

8、根據提示先安裝 mysql-community-libs包

[root@seiang software]# rpm -ivh mysql-community-libs-5.7.21-1.el7.x86_64.rpm

9、再次嘗試安裝mysql-client

[root@seiang software]# rpm -ivh mysql-community-client-5.7.21-1.el7.x86_64.rpm

warning: mysql-community-client-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

10、最后安裝mysql-server

[root@seiang software]# rpm -ivh mysql-community-server-5.7.21-1.el7.x86_64.rpm

warning: mysql-community-server-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing...                          ################################# [100%]

Updating / installing...

   1:mysql-community-server-5.7.21-1.e################################# [100%]

11、查看mysql的服務

[root@seiang software]# systemctl status mysqld.service

mysqld.service - MySQL Server

   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)

   Active: inactive (dead)

     Docs: man:mysqld(8)

           http://dev.mysql.com/doc/refman/en/using-systemd.html

12、啟動mysql服務

[root@seiang software]# systemctl start mysqld.service

[root@seiang software]#

[root@seiang software]# systemctl status mysqld.service

mysqld.service - MySQL Server

   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)

   Active: active (running) since Mon 2018-03-26 09:26:04 CST; 2s ago

13、mysql服務啟動成功，首先使用臨時的密碼進行登錄，查看臨時密碼

[root@seiang software]# grep "password" /var/log/mysqld.log

2018-03-25T11:18:09.770923Z 1 [Note] A temporary password is generated for root@localhost: &)2KIh?M3hr7


2018-03-26T01:25:57.938742Z 1 [Note] A temporary password is generated for root@localhost: v,esvf2?oj?T

（編輯：武林網）

上一篇：介于MHA架構的MySQL高可用故障自動切換架構

下一篇：Galera Cluster for MySQL監控狀態解說