CentOS 7 yum 安裝 MySQL5.7

標籤：ldo   ice   client   conf   reg   安裝完成   sea   bsp   tool   

1、下載 MySQL 官方的 Yum Repository ，官網地址：https://dev.mysql.com/downloads/repo/yum/

從 MySQL 官網選取合適的 MySQL 版本，擷取。

然後使用 wget 下載：

[[email protected] ~]# wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm--2017-10-19 04:44:56--  http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpmResolving dev.mysql.com (dev.mysql.com)... 137.254.60.11

 

2、安裝 yum Repository

[[email protected] ~]# lltotal 12-rw-r--r--. 1 root root 8984 Nov 12  2015 mysql57-community-release-el7-7.noarch.rpm[[email protected] ~]# yum -y install mysql57-community-release-el7-8.noarch.rpm Loaded plugins: fastestmirrorExamining mysql57-community-release-el7-8.noarch.rpm: mysql57-community-release-el7-8.noarchMarking mysql57-community-release-el7-8.noarch.rpm to be installedResolving Dependencies--> Running transaction check---> Package mysql57-community-release.noarch 0:el7-8 will be installed--> Finished Dependency ResolutionDependencies Resolved=========================================================================== Package        Arch   Version                             Repository                               Size===========================================================================Installing: mysql57-community-release                noarch el7-8 /mysql57-community-release-el7-8.noarch 8.2 kTransaction Summary===========================================================================Install  1 PackageTotal size: 8.2 kInstalled size: 8.2 kDownloading packages:Running transaction checkRunning transaction testTransaction test succeededRunning transaction  Installing : mysql57-community-release-el7-8.noarch                  1/1   Verifying  : mysql57-community-release-el7-8.noarch                  1/1 Installed:  mysql57-community-release.noarch 0:el7-8                                 Complete!

 

3、安裝 MySQL 服務端

查看 mysql server

[[email protected] ~]# yum search mysql-comLoaded plugins: fastestmirrormysql-connectors-community                          | 2.5 kB     00:00     mysql-tools-community                               | 2.5 kB     00:00     mysql57-community                                   | 2.5 kB     00:00     (1/3): mysql-connectors-community/x86_64/primary_db   |  16 kB   00:00     (2/3): mysql-tools-community/x86_64/primary_db        |  35 kB   00:00     (3/3): mysql57-community/x86_64/primary_db            | 124 kB   00:00     Loading mirror speeds from cached hostfile * base: mirrors.btte.net * extras: mirrors.cn99.com * updates: mirrors.sohu.com========================= N/S matched: mysql-com ==========================mysql-community-client.i686 : MySQL database client applications and toolsmysql-community-client.x86_64 : MySQL database client applications and                              : toolsmysql-community-common.i686 : MySQL database common files for server and                            : client libsmysql-community-common.x86_64 : MySQL database common files for server and                              : client libsmysql-community-devel.i686 : Development header files and libraries for                           : MySQL database client applicationsmysql-community-devel.x86_64 : Development header files and libraries for                             : MySQL database client applicationsmysql-community-embedded.i686 : MySQL embedded librarymysql-community-embedded.x86_64 : MySQL embedded librarymysql-community-embedded-compat.i686 : MySQL embedded compat librarymysql-community-embedded-compat.x86_64 : MySQL embedded compat librarymysql-community-embedded-devel.i686 : Development header files and     ...: libraries for MySQL as an embeddable librarymysql-community-embedded-devel.x86_64 : Development header files and     ...: libraries for MySQL as an embeddable librarymysql-community-libs.i686 : Shared libraries for MySQL database client                          : applicationsmysql-community-libs.x86_64 : Shared libraries for MySQL database client                            : applicationsmysql-community-libs-compat.i686 : Shared compat libraries for MySQL 5.6.25                                 : database client applicationsmysql-community-libs-compat.x86_64 : Shared compat libraries for MySQL                                   : 5.6.37 database client applicationsmysql-community-release.noarch : MySQL repository configuration for yummysql-community-server.x86_64 : A very fast and reliable SQL database                              : servermysql-community-test.x86_64 : Test suite for the MySQL database server  Name and summary matches only, use "search all" for everything.

 安裝

[[email protected] ~]# yum -y install mysql-community-server.x86_64Loaded plugins: fastestmirrorLoading mirror speeds from cached hostfile * base: mirrors.btte.net * extras: mirrors.cn99.com * updates: mirrors.sohu.comResolving Dependencies--> Running transaction check---> Package mariadb-server.x86_64 1:5.5.56-2.el7 will be obsoleted

 

等待執行安裝完成。

4、啟動 mysql 服務

然後啟動，注意 CentOS7 的啟動方式和以前不一樣，CentOS7 使用了 systemctl

[[email protected] ~]# systemctl start mysqld.service

 查看啟動是否成功

[[email protected] ~]# systemctl status mysqld.service● mysqld.service - MySQL Server   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)   Active: active (running) since Thu 2017-10-19 04:55:02 CST; 11s ago     Docs: man:mysqld(8)           http://dev.mysql.com/doc/refman/en/using-systemd.html  Process: 4346 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)  Process: 4271 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 4349 (mysqld)   CGroup: /system.slice/mysqld.service           └─4349 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysql...Oct 19 04:54:58 localhost.localdomain systemd[1]: Starting MySQL Server...Oct 19 04:55:02 localhost.localdomain systemd[1]: Started MySQL Server.Hint: Some lines were ellipsized, use -l to show in full.

上面顯示 active (running) 則表示已經正常啟動。

5、登陸資料庫

然後就可以進入資料庫了，這裡注意一點，MySQL5.7.6 之後會在啟動 mysql 進程的時候產生一個使用者密碼，首次登陸需要這個密碼才行。密碼儲存在 mysql 進程的日誌裡，即(/var/log/mysqld.log)

查看登陸密碼

[[email protected] ~]# cat /var/log/mysqld.log | grep ‘password‘2017-10-18T20:54:59.169015Z 1 [Note] A temporary password is generated for [email protected]: I-<k&>wb&0h*

 然後登陸

[[email protected] ~]# mysql -uroot -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.7.20Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.mysql> 

 

到這裡 MySQL 就完整安裝完成了。

6、修改 root 密碼

但是如果想正常使用還需要修改密碼，以前的 password()函數將會被拋棄，官方建議使用下面的命令來修改密碼

mysql> ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘new_password‘;ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

 密碼不能太簡單

這裡我們注意設定密碼 長度要大於8，同時要有數字，大小寫，特殊字元。

最後，安裝完了可以刪除 MySQL 的 Repository ，這樣可以減少 yum 檢查更新的時間，使用下面的命令。

[[email protected] ~]# yum -y remove mysql57-community-release-el7-8.noarch

 

CentOS 7 yum 安裝 MySQL5.7