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.
- Make sure current release of Enterprise Linux
- Install official MySQL repositories from MySQL.
- Check the new repositories.
- Check what version of MySQL we can have.
- Let's install MySQL Community Server 5.6.19.
- Let's see what have been installed by querying RPM.
- Enable mysqld service
- Start mysqld service.
- Set root password for the newly installed MySQL server.
- Test the availability of MySQL
- Open port 3306 for both runtime and permanent, if you allow remote accesses.
[root@primary01 ~]# cat /etc/redhat-release
CentOS Linux release 7.0.1406 (Core)
[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.
[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
[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.
[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) <[email protected]>"
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 <[email protected]>"
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!
[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
[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.[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
...
[root@primary01 ~]# mysqladmin -u root password
New password:
Confirm new password:
[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)
[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.