How to Install Newest LAMP on CentOS 7 Minimal (1/3) - MySQL

Installing MySQL on CentOS 7 is a little different from CentOS 6, because CentOS 7 adopts a different tool systemctl to control the life cycles of service, and the firewall configuration is also changed in this major version.

If you'd to install MySQL on CentOS 6, you may refer to this post: How to Install Newest MySQL on CentOS 6 from Official Repository.

Now, let's begin to install the newest MySQL from official site.

  1. Make sure current release of Enterprise Linux
  2. [root@primary01 ~]# cat /etc/redhat-release
    CentOS Linux release 7.0.1406 (Core)
  3. Install official MySQL repositories from MySQL.
  4. [root@primary01 ~]# rpm -Uvh http://repo.mysql.com//mysql-community-release-el7-5.noarch.rpm
    Retrieving http://repo.mysql.com//mysql-community-release-el7-5.noarch.rpm
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:mysql-community-release-el7-5    ################################# [100%]

    For other Linux distros or releases repositories, please refer to: MySQL :: MySQL Repositories MySQL :: Download MySQL Yum Repository.

  5. Check the new repositories.
  6. [root@primary01 ~]# ll /etc/yum.repos.d/
    total 24
    -rw-r--r--. 1 root root 1612 Jul  4 19:00 CentOS-Base.repo
    -rw-r--r--. 1 root root  640 Jul  4 19:00 CentOS-Debuginfo.repo
    -rw-r--r--. 1 root root 1331 Jul  4 19:00 CentOS-Sources.repo
    -rw-r--r--. 1 root root  156 Jul  4 19:00 CentOS-Vault.repo
    -rw-r--r--. 1 root root 1209 Jan 29 18:43 mysql-community.repo
    -rw-r--r--. 1 root root 1060 Jan 29 18:43 mysql-community-source.repo
  7. Check what version of MySQL we can have.
  8. [root@primary01 ~]# yum info mysql-community-server
    Loaded plugins: fastestmirror
    base                                                     | 3.6 kB     00:00
    extras                                                   | 3.3 kB     00:00
    mysql-connectors-community                               | 2.5 kB     00:00
    mysql-tools-community                                    | 2.5 kB     00:00
    mysql56-community                                        | 2.5 kB     00:00
    updates                                                  | 3.4 kB     00:00
    (1/7): extras/7/x86_64/primary_db                          |  15 kB   00:00
    (2/7): mysql-connectors-community/x86_64/primary_db        | 6.2 kB   00:00
    (3/7): mysql-tools-community/x86_64/primary_db             | 4.0 kB   00:00
    (4/7): mysql56-community/x86_64/primary_db                 |  35 kB   00:00
    (5/7): base/7/x86_64/group_gz                              | 157 kB   00:01
    (6/7): updates/7/x86_64/primary_db                         | 2.1 MB   00:06
    (7/7): base/7/x86_64/primary_db                            | 4.9 MB   00:20
    Determining fastest mirrors
     * base: mirror01.idc.hinet.net
     * extras: mirror01.idc.hinet.net
     * updates: mirror01.idc.hinet.net
    Available Packages
    Name        : mysql-community-server
    Arch        : x86_64
    Version     : 5.6.19
    Release     : 2.el7
    Size        : 57 M
    Repo        : mysql56-community/x86_64
    Summary     : A very fast and reliable SQL database server
    URL         : http://www.mysql.com/
    License     : Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights
                : reserved. Under GPLv2 license as shown in the Description field.
    Description : The MySQL(TM) software delivers a very fast, multi-threaded,
                : multi-user, and robust SQL (Structured Query Language) database
                : server. MySQL Server is intended for mission-critical, heavy-load
                : production systems as well as for embedding into mass-deployed
                : software. MySQL is a trademark of Oracle and/or its affiliates
                :
                : The MySQL software has Dual Licensing, which means you can use the
                : MySQL software free of charge under the GNU General Public License
                : (http://www.gnu.org/licenses/). You can also purchase commercial
                : MySQL licenses from Oracle and/or its affiliates if you do not
                : wish to be bound by the terms of the GPL. See the chapter
                : "Licensing and Support" in the manual for further info.
                :
                : The MySQL web site (http://www.mysql.com/) provides the latest
                : news and information about the MySQL software.  Also please see
                : the documentation and the manual for more information.
                :
                : This package includes the MySQL server binary as well as related
                : utilities to run and administer a MySQL server.
  9. Let's install MySQL Community Server 5.6.19.
  10. [root@primary01 ~]# yum -y install mysql-community-server
    Loaded plugins: fastestmirror
    Loading mirror speeds from cached hostfile
     * base: mirror01.idc.hinet.net
     * extras: mirror01.idc.hinet.net
     * updates: mirror01.idc.hinet.net
    Resolving Dependencies
    --> Running transaction check
    ---> Package mysql-community-server.x86_64 0:5.6.19-2.el7 will be installed
    --> Processing Dependency: mysql-community-common(x86-64) = 5.6.19-2.el7 for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: mysql-community-client(x86-64) = 5.6.19-2.el7 for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(warnings) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(strict) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(if) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(Sys::Hostname) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(POSIX) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(Getopt::Long) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(File::Temp) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(File::Spec) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(File::Path) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(File::Copy) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(File::Basename) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(Fcntl) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(Data::Dumper) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(DBI) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: net-tools for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: /usr/bin/perl for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Processing Dependency: libaio.so.1()(64bit) for package: mysql-community-server-5.6.19-2.el7.x86_64
    --> Running transaction check
    ---> Package libaio.x86_64 0:0.3.109-12.el7 will be installed
    ---> Package mysql-community-client.x86_64 0:5.6.19-2.el7 will be installed
    --> Processing Dependency: mysql-community-libs(x86-64) = 5.6.19-2.el7 for package: mysql-community-client-5.6.19-2.el7.x86_64
    --> Processing Dependency: perl(Exporter) for package: mysql-community-client-5.6.19-2.el7.x86_64
    ---> Package mysql-community-common.x86_64 0:5.6.19-2.el7 will be installed
    ---> Package net-tools.x86_64 0:2.0-0.17.20131004git.el7 will be installed
    ---> Package perl.x86_64 4:5.16.3-283.el7 will be installed
    --> Processing Dependency: perl-libs = 4:5.16.3-283.el7 for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl-macros for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl-libs for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-283.el7.x86_64
    --> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-283.el7.x86_64
    ---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
    --> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
    --> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
    ---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
    ---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
    ---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
    ---> Package perl-Getopt-Long.noarch 0:2.40-2.el7 will be installed
    --> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-2.el7.noarch
    --> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-2.el7.noarch
    ---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
    --> Running transaction check
    ---> Package mariadb-libs.x86_64 1:5.5.35-3.el7 will be obsoleted
    ---> Package mysql-community-libs.x86_64 0:5.6.19-2.el7 will be obsoleting
    ---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
    ---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
    ---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
    ---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
    --> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
    --> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
    --> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
    --> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
    ---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
    --> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
    --> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
    ---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
    --> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
    --> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
    ---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
    ---> Package perl-Socket.x86_64 0:2.010-3.el7 will be installed
    ---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
    ---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
    ---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
    ---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
    ---> Package perl-libs.x86_64 4:5.16.3-283.el7 will be installed
    ---> Package perl-macros.x86_64 4:5.16.3-283.el7 will be installed
    ---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
    ---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
    --> Running transaction check
    ---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
    ---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
    --> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
    --> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
    ---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
    ---> Package perl-Pod-Escapes.noarch 1:1.04-283.el7 will be installed
    ---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
    --> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
    --> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
    ---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
    --> Running transaction check
    ---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
    ---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
    ---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
    ---> Package perl-parent.noarch 1:0.225-244.el7 will be installed
    --> Finished Dependency Resolution

    Dependencies Resolved

    ================================================================================
     Package                Arch   Version                  Repository         Size
    ================================================================================
    Installing:
     mysql-community-libs   x86_64 5.6.19-2.el7             mysql56-community 2.0 M
         replacing  mariadb-libs.x86_64 1:5.5.35-3.el7
     mysql-community-server x86_64 5.6.19-2.el7             mysql56-community  57 M
    Installing for dependencies:
     libaio                 x86_64 0.3.109-12.el7           base               24 k
     mysql-community-client x86_64 5.6.19-2.el7             mysql56-community  19 M
     mysql-community-common x86_64 5.6.19-2.el7             mysql56-community 247 k
     net-tools              x86_64 2.0-0.17.20131004git.el7 base              304 k
     perl                   x86_64 4:5.16.3-283.el7         base              8.0 M
     perl-Carp              noarch 1.26-244.el7             base               19 k
     perl-Compress-Raw-Bzip2
                            x86_64 2.061-3.el7              base               32 k
     perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7            base               57 k
     perl-DBI               x86_64 1.627-4.el7              base              802 k
     perl-Data-Dumper       x86_64 2.145-3.el7              base               47 k
     perl-Encode            x86_64 2.51-7.el7               base              1.5 M
     perl-Exporter          noarch 5.68-3.el7               base               28 k
     perl-File-Path         noarch 2.09-2.el7               base               26 k
     perl-File-Temp         noarch 0.23.01-3.el7            base               56 k
     perl-Filter            x86_64 1.49-3.el7               base               76 k
     perl-Getopt-Long       noarch 2.40-2.el7               base               56 k
     perl-HTTP-Tiny         noarch 0.033-3.el7              base               38 k
     perl-IO-Compress       noarch 2.061-2.el7              base              260 k
     perl-Net-Daemon        noarch 0.48-5.el7               base               51 k
     perl-PathTools         x86_64 3.40-5.el7               base               82 k
     perl-PlRPC             noarch 0.2020-14.el7            base               36 k
     perl-Pod-Escapes       noarch 1:1.04-283.el7           base               49 k
     perl-Pod-Perldoc       noarch 3.20-4.el7               base               87 k
     perl-Pod-Simple        noarch 1:3.28-4.el7             base              216 k
     perl-Pod-Usage         noarch 1.63-3.el7               base               27 k
     perl-Scalar-List-Utils x86_64 1.27-248.el7             base               36 k
     perl-Socket            x86_64 2.010-3.el7              base               49 k
     perl-Storable          x86_64 2.45-3.el7               base               77 k
     perl-Text-ParseWords   noarch 3.29-4.el7               base               14 k
     perl-Time-Local        noarch 1.2300-2.el7             base               24 k
     perl-constant          noarch 1.27-2.el7               base               19 k
     perl-libs              x86_64 4:5.16.3-283.el7         base              686 k
     perl-macros            x86_64 4:5.16.3-283.el7         base               42 k
     perl-parent            noarch 1:0.225-244.el7          base               12 k
     perl-podlators         noarch 2.5.1-3.el7              base              112 k
     perl-threads           x86_64 1.87-4.el7               base               49 k
     perl-threads-shared    x86_64 1.43-6.el7               base               39 k

    Transaction Summary
    ================================================================================
    Install  2 Packages (+37 Dependent packages)

    Total download size: 91 M
    Downloading packages:
    warning: /var/cache/yum/x86_64/7/base/packages/libaio-0.3.109-12.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
    Public key for libaio-0.3.109-12.el7.x86_64.rpm is not installed
    (1/39): libaio-0.3.109-12.el7.x86_64.rpm                   |  24 kB   00:00
    warning: /var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.19-2.el7.x86_64.rpm: V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Public key for mysql-community-common-5.6.19-2.el7.x86_64.rpm is not installed
    (2/39): mysql-community-common-5.6.19-2.el7.x86_64.rpm     | 247 kB   00:01
    (3/39): mysql-community-libs-5.6.19-2.el7.x86_64.rpm       | 2.0 MB   00:14
    (4/39): perl-Carp-1.26-244.el7.noarch.rpm                  |  19 kB   00:01
    (5/39): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm     |  32 kB   00:00
    (6/39): net-tools-2.0-0.17.20131004git.el7.x86_64.rpm      | 304 kB   00:02
    (7/39): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm      |  57 kB   00:01
    (8/39): perl-Data-Dumper-2.145-3.el7.x86_64.rpm            |  47 kB   00:01
    (9/39): perl-DBI-1.627-4.el7.x86_64.rpm                    | 802 kB   00:04
    (10/39): perl-Exporter-5.68-3.el7.noarch.rpm               |  28 kB   00:00
    (11/39): perl-File-Path-2.09-2.el7.noarch.rpm              |  26 kB   00:00
    (12/39): perl-File-Temp-0.23.01-3.el7.noarch.rpm           |  56 kB   00:00
    (13/39): perl-Filter-1.49-3.el7.x86_64.rpm                 |  76 kB   00:03
    (14/39): perl-Getopt-Long-2.40-2.el7.noarch.rpm            |  56 kB   00:04
    (15/39): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm             |  38 kB   00:03
    (16/39): perl-5.16.3-283.el7.x86_64.rpm                    | 8.0 MB   00:29
    (17/39): perl-IO-Compress-2.061-2.el7.noarch.rpm           | 260 kB   00:11
    (18/39): perl-PathTools-3.40-5.el7.x86_64.rpm              |  82 kB   00:00
    (19/39): perl-Net-Daemon-0.48-5.el7.noarch.rpm             |  51 kB   00:01
    (20/39): perl-PlRPC-0.2020-14.el7.noarch.rpm               |  36 kB   00:00
    (21/39): perl-Pod-Escapes-1.04-283.el7.noarch.rpm          |  49 kB   00:01
    (22/39): perl-Encode-2.51-7.el7.x86_64.rpm                 | 1.5 MB   00:27
    (23/39): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm            |  87 kB   00:01
    (24/39): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm    |  36 kB   00:00
    (25/39): perl-Pod-Simple-3.28-4.el7.noarch.rpm             | 216 kB   00:00
    (26/39): perl-Pod-Usage-1.63-3.el7.noarch.rpm              |  27 kB   00:00
    (27/39): perl-Socket-2.010-3.el7.x86_64.rpm                |  49 kB   00:00
    (28/39): perl-Storable-2.45-3.el7.x86_64.rpm               |  77 kB   00:00
    (29/39): perl-Text-ParseWords-3.29-4.el7.noarch.rpm        |  14 kB   00:00
    (30/39): perl-Time-Local-1.2300-2.el7.noarch.rpm           |  24 kB   00:00
    (31/39): perl-constant-1.27-2.el7.noarch.rpm               |  19 kB   00:00
    (32/39): perl-parent-0.225-244.el7.noarch.rpm              |  12 kB   00:00
    (33/39): perl-macros-5.16.3-283.el7.x86_64.rpm             |  42 kB   00:00
    (34/39): perl-podlators-2.5.1-3.el7.noarch.rpm             | 112 kB   00:00
    (35/39): perl-threads-1.87-4.el7.x86_64.rpm                |  49 kB   00:00
    (36/39): perl-threads-shared-1.43-6.el7.x86_64.rpm         |  39 kB   00:00
    (37/39): perl-libs-5.16.3-283.el7.x86_64.rpm               | 686 kB   00:09
    (38/39): mysql-community-client-5.6.19-2.el7.x86_64.rpm    |  19 MB   01:45
    (39/39): mysql-community-server-5.6.19-2.el7.x86_64.rpm    |  57 MB   04:33
    --------------------------------------------------------------------------------
    Total                                              322 kB/s |  91 MB  04:48
    Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
    Importing GPG key 0xF4A80EB5:
     Userid     : "CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>"
     Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5
     Package    : centos-release-7-0.1406.el7.centos.2.3.x86_64 (@anaconda)
     From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
    Retrieving key from file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
    Importing GPG key 0x5072E1F5:
     Userid     : "MySQL Release Engineering <mysql-build@oss.oracle.com>"
     Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
     Package    : mysql-community-release-el7-5.noarch (installed)
     From       : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
    Warning: RPMDB altered outside of yum.
      Installing : mysql-community-common-5.6.19-2.el7.x86_64                  1/40
      Installing : mysql-community-libs-5.6.19-2.el7.x86_64                    2/40
      Installing : 1:perl-parent-0.225-244.el7.noarch                          3/40
      Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                           4/40
      Installing : perl-podlators-2.5.1-3.el7.noarch                           5/40
      Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                          6/40
      Installing : perl-Encode-2.51-7.el7.x86_64                               7/40
      Installing : 1:perl-Pod-Escapes-1.04-283.el7.noarch                      8/40
      Installing : perl-Text-ParseWords-3.29-4.el7.noarch                      9/40
      Installing : perl-Pod-Usage-1.63-3.el7.noarch                           10/40
      Installing : 4:perl-libs-5.16.3-283.el7.x86_64                          11/40
      Installing : 4:perl-macros-5.16.3-283.el7.x86_64                        12/40
      Installing : perl-Storable-2.45-3.el7.x86_64                            13/40
      Installing : perl-Exporter-5.68-3.el7.noarch                            14/40
      Installing : perl-Socket-2.010-3.el7.x86_64                             15/40
      Installing : perl-Carp-1.26-244.el7.noarch                              16/40
      Installing : perl-PathTools-3.40-5.el7.x86_64                           17/40
      Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                 18/40
      Installing : perl-Time-Local-1.2300-2.el7.noarch                        19/40
      Installing : perl-constant-1.27-2.el7.noarch                            20/40
      Installing : perl-File-Temp-0.23.01-3.el7.noarch                        21/40
      Installing : perl-File-Path-2.09-2.el7.noarch                           22/40
      Installing : perl-threads-shared-1.43-6.el7.x86_64                      23/40
      Installing : perl-threads-1.87-4.el7.x86_64                             24/40
      Installing : perl-Filter-1.49-3.el7.x86_64                              25/40
      Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                        26/40
      Installing : perl-Getopt-Long-2.40-2.el7.noarch                         27/40
      Installing : 4:perl-5.16.3-283.el7.x86_64                               28/40
      Installing : perl-Data-Dumper-2.145-3.el7.x86_64                        29/40
      Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                 30/40
      Installing : perl-Net-Daemon-0.48-5.el7.noarch                          31/40
      Installing : mysql-community-client-5.6.19-2.el7.x86_64                 32/40
      Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                33/40
      Installing : perl-IO-Compress-2.061-2.el7.noarch                        34/40
      Installing : perl-PlRPC-0.2020-14.el7.noarch                            35/40
      Installing : perl-DBI-1.627-4.el7.x86_64                                36/40
      Installing : libaio-0.3.109-12.el7.x86_64                               37/40
      Installing : net-tools-2.0-0.17.20131004git.el7.x86_64                  38/40
      Installing : mysql-community-server-5.6.19-2.el7.x86_64                 39/40
      Erasing    : 1:mariadb-libs-5.5.35-3.el7.x86_64                         40/40
      Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                           1/40
      Verifying  : perl-threads-shared-1.43-6.el7.x86_64                       2/40
      Verifying  : perl-Storable-2.45-3.el7.x86_64                             3/40
      Verifying  : net-tools-2.0-0.17.20131004git.el7.x86_64                   4/40
      Verifying  : perl-Exporter-5.68-3.el7.noarch                             5/40
      Verifying  : perl-PathTools-3.40-5.el7.x86_64                            6/40
      Verifying  : 4:perl-5.16.3-283.el7.x86_64                                7/40
      Verifying  : libaio-0.3.109-12.el7.x86_64                                8/40
      Verifying  : mysql-community-server-5.6.19-2.el7.x86_64                  9/40
      Verifying  : 1:perl-parent-0.225-244.el7.noarch                         10/40
      Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                 11/40
      Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                          12/40
      Verifying  : 4:perl-libs-5.16.3-283.el7.x86_64                          13/40
      Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                        14/40
      Verifying  : mysql-community-libs-5.6.19-2.el7.x86_64                   15/40
      Verifying  : perl-Time-Local-1.2300-2.el7.noarch                        16/40
      Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                         17/40
      Verifying  : perl-DBI-1.627-4.el7.x86_64                                18/40
      Verifying  : perl-Socket-2.010-3.el7.x86_64                             19/40
      Verifying  : 4:perl-macros-5.16.3-283.el7.x86_64                        20/40
      Verifying  : mysql-community-client-5.6.19-2.el7.x86_64                 21/40
      Verifying  : perl-Carp-1.26-244.el7.noarch                              22/40
      Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                        23/40
      Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                 24/40
      Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                25/40
      Verifying  : perl-IO-Compress-2.061-2.el7.noarch                        26/40
      Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                           27/40
      Verifying  : perl-PlRPC-0.2020-14.el7.noarch                            28/40
      Verifying  : perl-Encode-2.51-7.el7.x86_64                              29/40
      Verifying  : perl-podlators-2.5.1-3.el7.noarch                          30/40
      Verifying  : perl-Getopt-Long-2.40-2.el7.noarch                         31/40
      Verifying  : perl-constant-1.27-2.el7.noarch                            32/40
      Verifying  : perl-File-Path-2.09-2.el7.noarch                           33/40
      Verifying  : perl-threads-1.87-4.el7.x86_64                             34/40
      Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                        35/40
      Verifying  : perl-Filter-1.49-3.el7.x86_64                              36/40
      Verifying  : 1:perl-Pod-Escapes-1.04-283.el7.noarch                     37/40
      Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                     38/40
      Verifying  : mysql-community-common-5.6.19-2.el7.x86_64                 39/40
      Verifying  : 1:mariadb-libs-5.5.35-3.el7.x86_64                         40/40

    Installed:
      mysql-community-libs.x86_64 0:5.6.19-2.el7
      mysql-community-server.x86_64 0:5.6.19-2.el7

    Dependency Installed:
      libaio.x86_64 0:0.3.109-12.el7
      mysql-community-client.x86_64 0:5.6.19-2.el7
      mysql-community-common.x86_64 0:5.6.19-2.el7
      net-tools.x86_64 0:2.0-0.17.20131004git.el7
      perl.x86_64 4:5.16.3-283.el7
      perl-Carp.noarch 0:1.26-244.el7
      perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7
      perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7
      perl-DBI.x86_64 0:1.627-4.el7
      perl-Data-Dumper.x86_64 0:2.145-3.el7
      perl-Encode.x86_64 0:2.51-7.el7
      perl-Exporter.noarch 0:5.68-3.el7
      perl-File-Path.noarch 0:2.09-2.el7
      perl-File-Temp.noarch 0:0.23.01-3.el7
      perl-Filter.x86_64 0:1.49-3.el7
      perl-Getopt-Long.noarch 0:2.40-2.el7
      perl-HTTP-Tiny.noarch 0:0.033-3.el7
      perl-IO-Compress.noarch 0:2.061-2.el7
      perl-Net-Daemon.noarch 0:0.48-5.el7
      perl-PathTools.x86_64 0:3.40-5.el7
      perl-PlRPC.noarch 0:0.2020-14.el7
      perl-Pod-Escapes.noarch 1:1.04-283.el7
      perl-Pod-Perldoc.noarch 0:3.20-4.el7
      perl-Pod-Simple.noarch 1:3.28-4.el7
      perl-Pod-Usage.noarch 0:1.63-3.el7
      perl-Scalar-List-Utils.x86_64 0:1.27-248.el7
      perl-Socket.x86_64 0:2.010-3.el7
      perl-Storable.x86_64 0:2.45-3.el7
      perl-Text-ParseWords.noarch 0:3.29-4.el7
      perl-Time-Local.noarch 0:1.2300-2.el7
      perl-constant.noarch 0:1.27-2.el7
      perl-libs.x86_64 4:5.16.3-283.el7
      perl-macros.x86_64 4:5.16.3-283.el7
      perl-parent.noarch 1:0.225-244.el7
      perl-podlators.noarch 0:2.5.1-3.el7
      perl-threads.x86_64 0:1.87-4.el7
      perl-threads-shared.x86_64 0:1.43-6.el7

    Replaced:
      mariadb-libs.x86_64 1:5.5.35-3.el7

    Complete!
  11. Let's see what have been installed by querying RPM.
  12. [root@primary01 ~]# rpm -qa | grep mysql
    mysql-community-common-5.6.19-2.el7.x86_64
    mysql-community-server-5.6.19-2.el7.x86_64
    mysql-community-release-el7-5.noarch
    mysql-community-libs-5.6.19-2.el7.x86_64
    mysql-community-client-5.6.19-2.el7.x86_64
  13. Enable mysqld service
  14. [root@primary01 ~]# systemctl enable mysqld
    ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/mysql.service'
    ln -s '/usr/lib/systemd/system/mysqld.service' '/etc/systemd/system/multi-user.target.wants/mysqld.service'
    You may also use the old command chkconfig mysqld on to enable it.
  15. Start mysqld service.
  16. [root@primary01 ~]# systemctl status mysqld
    mysqld.service - MySQL Community Server
       Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
       Active: inactive (dead)
    [root@primary01 ~]# systemctl start mysqld
    [root@primary01 ~]# systemctl status mysqld
    mysqld.service - MySQL Community Server
       Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
       Active: active (running) since Tue 2014-07-29 19:26:14 CST; 8s ago
    ...
    [root@primary01 ~]# systemctl show mysqld
    Id=mysqld.service
    Names=mysqld.service
    ...
  17. Set root password for the newly installed MySQL server.
  18. [root@primary01 ~]# mysqladmin -u root password
    New password:
    Confirm new password:
  19. Test the availability of MySQL
  20. [root@primary01 ~]# mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or g.
    Your MySQL connection id is 3
    Server version: 5.6.19 MySQL Community Server (GPL)

    Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

    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> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | mysql              |
    | performance_schema |
    +--------------------+
    3 rows in set (0.00 sec)
  21. Open port 3306 for both runtime and permanent, if you allow remote accesses.
  22. [root@primary01 ~]# firewall-cmd --zone=public --add-port=3306/tcp
    success
    [root@primary01 ~]# firewall-cmd --permanent --zone=public --add-port=3306/tcp
    success
    Otherwise, you may refer to this post about simulating remote accesses just like locals without opening port 3306. 3 Ways to Connect Remote MySQL Databases Like Locals.

    You don't have to manually enable firewalld service, because it's enabled by default.
    [root@primary01 ~]# systemctl status firewalld
    firewalld.service - firewalld - dynamic firewall daemon
       Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled)
    ...

Now, we have installed the newest MySQL server on CentOS 7.0 minimal release.

Leave a Reply

Your email address will not be published. Required fields are marked *