Mysql Installation Steps on RHEL 7 for Database versions 5.6.x and 5.7.

========================================================================

RHEL 7 - DB Version 5.6.29

========================================================================

[root@hostname /]# useradd -g dba -u 888 -d /tmp/mysql -m mysql

[root@hostname /]# passwd mysql

Changing password for user mysql.

New password:

BAD PASSWORD: The password is shorter than 8 characters

Retype new password:

passwd: all authentication tokens updated successfully.

[root@hostname 5.6.29]# pwd

/tmp/mysql/5.6.29

[root@hostname 5.6.29]# ls -ltr

total 466084

-rw-r--r-- 1 7155 wheel 20018036 Jan 15 23:29 MySQL-client-5.6.29-1.el7.x86_64.rpm

-rw-r--r-- 1 7155 wheel 3549396 Jan 15 23:29 MySQL-devel-5.6.29-1.el7.x86_64.rpm

-rw-r--r-- 1 7155 wheel 92504844 Jan 15 23:29 MySQL-embedded-5.6.29-1.el7.x86_64.rpm

-rw-r--r-- 1 7155 wheel 60801520 Jan 15 23:30 MySQL-server-5.6.29-1.el7.x86_64.rpm

-rw-r--r-- 1 7155 wheel 2106540 Jan 15 23:30 MySQL-shared-5.6.29-1.el7.x86_64.rpm

-rw-r--r-- 1 7155 wheel 59638388 Jan 15 23:30 MySQL-test-5.6.29-1.el7.x86_64.rpm

-rw-r--r-- 1 mysql games 238632960 Apr 11 14:22 MySQL-5.6.29-1.el7.x86_64.rpm-bundle.tar

[root@hostname 5.6.29]# rpm -ivh MySQL-client-5.6.29-1.el7.x86_64.rpm MySQL-server-5.6.29-1.el7.x86_64.rpm MySQL-shared-5.6.29-1.el7.x86_64.rpm

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

error: Failed dependencies:

/usr/bin/perl is needed by MySQL-client-5.6.29-1.el7.x86_64

/usr/bin/perl is needed by MySQL-server-5.6.29-1.el7.x86_64

libaio.so.1()(64bit) is needed by MySQL-server-5.6.29-1.el7.x86_64

libaio.so.1(LIBAIO_0.1)(64bit) is needed by MySQL-server-5.6.29-1.el7.x86_64

libaio.so.1(LIBAIO_0.4)(64bit) is needed by MySQL-server-5.6.29-1.el7.x86_64

[root@hostname 5.6.29]# yum install libaio

Loaded plugins: product-id, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Resolving Dependencies

--> Running transaction check

---> Package libaio.x86_64 0:0.3.109-12.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

================================================================

Package Arch Version Repository Size

================================================================

Installing:

libaio x86_64 0.3.109-12.el7 base 24 k

Transaction Summary

================================================================

Install 1 Package

Total download size: 24 k

Installed size: 38 k

Is this ok [y/d/N]: y

Downloading packages:

libaio-0.3.109-12.el7.x86_64.rpm | 24 kB 00:00:01

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : libaio-0.3.109-12.el7.x86_64 1/1

Verifying : libaio-0.3.109-12.el7.x86_64 1/1

Installed:

libaio.x86_64 0:0.3.109-12.el7

Complete!

[root@hostname 5.6.29]# rpm -ivh MySQL-client-5.6.29-1.el7.x86_64.rpm MySQL-server-5.6.29-1.el7.x86_64.rpm MySQL-shared-5.6.29-1.el7.x86_64.rpm

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

error: Failed dependencies:

/usr/bin/perl is needed by MySQL-client-5.6.29-1.el7.x86_64

/usr/bin/perl is needed by MySQL-server-5.6.29-1.el7.x86_64

[root@hostname 5.6.29]# yum install perl

Loaded plugins: product-id, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Resolving Dependencies

--> Running transaction check

---> 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(File::Path) 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(Time::Local) for package: 4:perl-5.16.3-283.el7.x86_64

--> Processing Dependency: perl(File::Spec) 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(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: perl(File::Spec::Unix) 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(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-libs 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(File::Temp) 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(threads::shared) for package: 4:perl-5.16.3-283.el7.x86_64

--> Processing Dependency: perl(Cwd) 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(Getopt::Long) for package: 4:perl-5.16.3-283.el7.x86_64

--> Processing Dependency: perl(Exporter) for package: 4:perl-5.16.3-283.el7.x86_64

--> Processing Dependency: perl(File::Spec::Functions) 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

--> Running transaction check

---> 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-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-Filter.x86_64 0:1.49-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

---> 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-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-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-Pod-Escapes.noarch 1:1.04-283.el7 will be installed

---> 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-Text-ParseWords.noarch 0:3.29-4.el7 will be installed

--> Running transaction check

---> 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-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:

perl x86_64 4:5.16.3-283.el7 base 8.0 M

Installing for dependencies:

perl-Carp noarch 1.26-244.el7 base 19 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 27 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-PathTools x86_64 3.40-5.el7 base 83 k

perl-Pod-Escapes noarch 1:1.04-283.el7 base 50 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 1 Package (+25 Dependent packages)

Total download size: 11 M

Installed size: 36 M

Is this ok [y/d/N]: y

Downloading packages:

(1/26): perl-Carp-1.26-244.el7.noarch.rpm | 19 kB 00:00:00

(2/26): perl-Encode-2.51-7.el7.x86_64.rpm | 1.5 MB 00:00:02

(3/26): perl-Exporter-5.68-3.el7.noarch.rpm | 28 kB 00:00:00

(4/26): perl-File-Path-2.09-2.el7.noarch.rpm | 27 kB 00:00:01

(5/26): perl-5.16.3-283.el7.x86_64.rpm | 8.0 MB 00:00:05

(6/26): perl-File-Temp-0.23.01-3.el7.noarch.rpm | 56 kB 00:00:00

(7/26): perl-Filter-1.49-3.el7.x86_64.rpm | 76 kB 00:00:00

(8/26): perl-Getopt-Long-2.40-2.el7.noarch.rpm | 56 kB 00:00:00

(9/26): perl-HTTP-Tiny-0.033-3.el7.noarch.rpm | 38 kB 00:00:00

(10/26): perl-PathTools-3.40-5.el7.x86_64.rpm | 83 kB 00:00:00

(11/26): perl-Pod-Escapes-1.04-283.el7.noarch.rpm | 50 kB 00:00:01

(12/26): perl-Pod-Perldoc-3.20-4.el7.noarch.rpm | 87 kB 00:00:01

(13/26): perl-Pod-Simple-3.28-4.el7.noarch.rpm | 216 kB 00:00:00

(14/26): perl-Pod-Usage-1.63-3.el7.noarch.rpm | 27 kB 00:00:00

(15/26): perl-Scalar-List-Utils-1.27-248.el7.x86_64.rpm | 36 kB 00:00:00

(16/26): perl-Socket-2.010-3.el7.x86_64.rpm | 49 kB 00:00:01

(17/26): perl-Storable-2.45-3.el7.x86_64.rpm | 77 kB 00:00:00

(18/26): perl-Text-ParseWords-3.29-4.el7.noarch.rpm | 14 kB 00:00:00

(19/26): perl-Time-Local-1.2300-2.el7.noarch.rpm | 24 kB 00:00:00

(20/26): perl-constant-1.27-2.el7.noarch.rpm | 19 kB 00:00:00

(21/26): perl-macros-5.16.3-283.el7.x86_64.rpm | 42 kB 00:00:00

(22/26): perl-parent-0.225-244.el7.noarch.rpm | 12 kB 00:00:00

(23/26): perl-libs-5.16.3-283.el7.x86_64.rpm | 686 kB 00:00:01

(24/26): perl-threads-1.87-4.el7.x86_64.rpm | 49 kB 00:00:00

(25/26): perl-podlators-2.5.1-3.el7.noarch.rpm | 112 kB 00:00:01

(26/26): perl-threads-shared-1.43-6.el7.x86_64.rpm | 39 kB 00:00:00

-----------------------------------------------------------------------------------------------------

Total 719 kB/s | 11 MB 00:00:16

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : 1:perl-parent-0.225-244.el7.noarch 1/26

Installing : perl-HTTP-Tiny-0.033-3.el7.noarch 2/26

Installing : perl-podlators-2.5.1-3.el7.noarch 3/26

Installing : perl-Pod-Perldoc-3.20-4.el7.noarch 4/26

Installing : 1:perl-Pod-Escapes-1.04-283.el7.noarch 5/26

Installing : perl-Text-ParseWords-3.29-4.el7.noarch 6/26

Installing : perl-Encode-2.51-7.el7.x86_64 7/26

Installing : perl-Pod-Usage-1.63-3.el7.noarch 8/26

Installing : 4:perl-libs-5.16.3-283.el7.x86_64 9/26

Installing : 4:perl-macros-5.16.3-283.el7.x86_64 10/26

Installing : perl-Storable-2.45-3.el7.x86_64 11/26

Installing : perl-Exporter-5.68-3.el7.noarch 12/26

Installing : perl-constant-1.27-2.el7.noarch 13/26

Installing : perl-Time-Local-1.2300-2.el7.noarch 14/26

Installing : perl-Socket-2.010-3.el7.x86_64 15/26

Installing : perl-Carp-1.26-244.el7.noarch 16/26

Installing : perl-PathTools-3.40-5.el7.x86_64 17/26

Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64 18/26

Installing : perl-File-Temp-0.23.01-3.el7.noarch 19/26

Installing : perl-File-Path-2.09-2.el7.noarch 20/26

Installing : perl-threads-shared-1.43-6.el7.x86_64 21/26

Installing : perl-threads-1.87-4.el7.x86_64 22/26

Installing : perl-Filter-1.49-3.el7.x86_64 23/26

Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch 24/26

Installing : perl-Getopt-Long-2.40-2.el7.noarch 25/26

Installing : 4:perl-5.16.3-283.el7.x86_64 26/26

Verifying : perl-HTTP-Tiny-0.033-3.el7.noarch 1/26

Verifying : perl-threads-shared-1.43-6.el7.x86_64 2/26

Verifying : perl-Storable-2.45-3.el7.x86_64 3/26

Verifying : perl-Exporter-5.68-3.el7.noarch 4/26

Verifying : perl-constant-1.27-2.el7.noarch 5/26

Verifying : perl-PathTools-3.40-5.el7.x86_64 6/26

Verifying : 1:perl-Pod-Escapes-1.04-283.el7.noarch 7/26

Verifying : 1:perl-parent-0.225-244.el7.noarch 8/26

Verifying : 1:perl-Pod-Simple-3.28-4.el7.noarch 9/26

Verifying : perl-File-Temp-0.23.01-3.el7.noarch 10/26

Verifying : 4:perl-libs-5.16.3-283.el7.x86_64 11/26

Verifying : perl-Time-Local-1.2300-2.el7.noarch 12/26

Verifying : perl-Pod-Perldoc-3.20-4.el7.noarch 13/26

Verifying : perl-Socket-2.010-3.el7.x86_64 14/26

Verifying : 4:perl-macros-5.16.3-283.el7.x86_64 15/26

Verifying : 4:perl-5.16.3-283.el7.x86_64 16/26

Verifying : perl-Carp-1.26-244.el7.noarch 17/26

Verifying : perl-Scalar-List-Utils-1.27-248.el7.x86_64 18/26

Verifying : perl-Pod-Usage-1.63-3.el7.noarch 19/26

Verifying : perl-Encode-2.51-7.el7.x86_64 20/26

Verifying : perl-podlators-2.5.1-3.el7.noarch 21/26

Verifying : perl-Getopt-Long-2.40-2.el7.noarch 22/26

Verifying : perl-File-Path-2.09-2.el7.noarch 23/26

Verifying : perl-threads-1.87-4.el7.x86_64 24/26

Verifying : perl-Filter-1.49-3.el7.x86_64 25/26

Verifying : perl-Text-ParseWords-3.29-4.el7.noarch 26/26

Installed:

perl.x86_64 4:5.16.3-283.el7

Dependency Installed:

perl-Carp.noarch 0:1.26-244.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-PathTools.x86_64 0:3.40-5.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

Complete!

[root@hostname 5.6.29]# rpm -qa | grep -i mariadb-libs

mariadb-libs-5.5.35-3.el7.x86_64

[root@hostname 5.6.29]# rpm -e mariadb-libs-5.5.35-3.el7.x86_64

error: Failed dependencies:

libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64

libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64

[root@hostname 5.6.29]# rpm -e mariadb-libs-5.5.35-3.el7.x86_64 --nodeps

[root@hostname 5.6.29]# rpm -ivh MySQL-client-5.6.29-1.el7.x86_64.rpm MySQL-server-5.6.29-1.el7.x86_64.rpm MySQL-shared-5.6.29-1.el7.x86_64.rpm

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

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

Updating / installing...

1:MySQL-shared-5.6.29-1.el7 ################################# [ 33%]

2:MySQL-server-5.6.29-1.el7 ################################# [ 67%]

warning: group mysql does not exist - using root

FATAL ERROR: please install the following Perl modules before executing /usr/bin/mysql_install_db:

Data::Dumper

3:MySQL-client-5.6.29-1.el7 ################################# [100%]

Need to install perl-Data-Dumper.x86_64 : Stringify perl data structures, suitable for printing and eval

Dependency Package : perl-Data-Dumper.x86_64

[root@hostname 5.6.29]# yum install perl-Data-Dumper.x86_64

Loaded plugins: product-id, subscription-manager

This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.

Resolving Dependencies

--> Running transaction check

---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

===========================================================

Package Arch Version Repository Size

===========================================================

Installing:

perl-Data-Dumper x86_64 2.145-3.el7 base 47 k

Transaction Summary

===========================================================

Install 1 Package

Total download size: 47 k

Installed size: 97 k

Is this ok [y/d/N]: y

Downloading packages:

perl-Data-Dumper-2.145-3.el7.x86_64.rpm | 47 kB 00:00:02

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

Installing : perl-Data-Dumper-2.145-3.el7.x86_64 1/1

Verifying : perl-Data-Dumper-2.145-3.el7.x86_64 1/1

Installed:

perl-Data-Dumper.x86_64 0:2.145-3.el7

Complete!

[root@hostname 5.6.29]# rpm -ivh MySQL-client-5.6.29-1.el7.x86_64.rpm

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

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

Updating / installing...

1:MySQL-client-5.6.29-1.el7 ################################# [100%]

[root@hostname 5.6.29]# rpm -ivh MySQL-shared-5.6.29-1.el7.x86_64.rpm

warning: MySQL-shared-5.6.29-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

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

Updating / installing...

1:MySQL-shared-5.6.29-1.el7 ################################# [100%]

[root@hostname5.6.29]# rpm -ivh MySQL-server-5.6.29-1.el7.x86_64.rpm

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

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

Updating / installing...

1:MySQL-server-5.6.29-1.el7 ################################# [100%]

2016-04-11 14:42:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-04-11 14:42:29 0 [Note] /usr/sbin/mysqld (mysqld 5.6.29) starting as process 8536 ...

2016-04-11 14:42:29 8536 [Note] InnoDB: Using atomics to ref count buffer pool pages

2016-04-11 14:42:29 8536 [Note] InnoDB: The InnoDB memory heap is disabled

2016-04-11 14:42:29 8536 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-04-11 14:42:29 8536 [Note] InnoDB: Memory barrier is not used

2016-04-11 14:42:29 8536 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-04-11 14:42:29 8536 [Note] InnoDB: Using Linux native AIO

2016-04-11 14:42:29 8536 [Note] InnoDB: Using CPU crc32 instructions

2016-04-11 14:42:29 8536 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2016-04-11 14:42:29 8536 [Note] InnoDB: Completed initialization of buffer pool

2016-04-11 14:42:29 8536 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!

2016-04-11 14:42:29 8536 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB

2016-04-11 14:42:29 8536 [Note] InnoDB: Database physically writes the file full: wait...

2016-04-11 14:42:30 8536 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB

2016-04-11 14:42:33 8536 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB

2016-04-11 14:42:34 8536 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0

2016-04-11 14:42:34 8536 [Warning] InnoDB: New log files created, LSN=45781

2016-04-11 14:42:34 8536 [Note] InnoDB: Doublewrite buffer not found: creating new

2016-04-11 14:42:34 8536 [Note] InnoDB: Doublewrite buffer created

2016-04-11 14:42:34 8536 [Note] InnoDB: 128 rollback segment(s) are active.

2016-04-11 14:42:34 8536 [Warning] InnoDB: Creating foreign key constraint system tables.

2016-04-11 14:42:34 8536 [Note] InnoDB: Foreign key constraint system tables created

2016-04-11 14:42:34 8536 [Note] InnoDB: Creating tablespace and datafile system tables.

2016-04-11 14:42:34 8536 [Note] InnoDB: Tablespace and datafile system tables created.

2016-04-11 14:42:34 8536 [Note] InnoDB: Waiting for purge to start

2016-04-11 14:42:34 8536 [Note] InnoDB: 5.6.29 started; log sequence number 0

A random root password has been set. You will find it in '/root/.mysql_secret'.

2016-04-11 14:42:34 8536 [Note] Binlog end

2016-04-11 14:42:34 8536 [Note] InnoDB: FTS optimize thread exiting.

2016-04-11 14:42:34 8536 [Note] InnoDB: Starting shutdown...

2016-04-11 14:42:36 8536 [Note] InnoDB: Shutdown completed; log sequence number 1625977

2016-04-11 14:42:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-04-11 14:42:36 0 [Note] /usr/sbin/mysqld (mysqld 5.6.29) starting as process 8558 ...

2016-04-11 14:42:36 8558 [Note] InnoDB: Using atomics to ref count buffer pool pages

2016-04-11 14:42:36 8558 [Note] InnoDB: The InnoDB memory heap is disabled

2016-04-11 14:42:36 8558 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-04-11 14:42:36 8558 [Note] InnoDB: Memory barrier is not used

2016-04-11 14:42:36 8558 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-04-11 14:42:36 8558 [Note] InnoDB: Using Linux native AIO

2016-04-11 14:42:36 8558 [Note] InnoDB: Using CPU crc32 instructions

2016-04-11 14:42:36 8558 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2016-04-11 14:42:36 8558 [Note] InnoDB: Completed initialization of buffer pool

2016-04-11 14:42:36 8558 [Note] InnoDB: Highest supported file format is Barracuda.

2016-04-11 14:42:36 8558 [Note] InnoDB: 128 rollback segment(s) are active.

2016-04-11 14:42:36 8558 [Note] InnoDB: Waiting for purge to start

2016-04-11 14:42:36 8558 [Note] InnoDB: 5.6.29 started; log sequence number 1625977

2016-04-11 14:42:38 8558 [Note] Binlog end

2016-04-11 14:42:38 8558 [Note] InnoDB: FTS optimize thread exiting.

2016-04-11 14:42:38 8558 [Note] InnoDB: Starting shutdown...

2016-04-11 14:42:39 8558 [Note] InnoDB: Shutdown completed; log sequence number 1625987

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !

You will find that password in '/root/.mysql_secret'.

You must change that password on your first connect,no other statement but 'SET PASSWORD' will be accepted.See the manual for the semantics of the 'password expired' flag.

Also, the account for the anonymous user has been removed.

In addition, you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test database.This is strongly recommended for production servers.

See the manual for more instructions.Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

New default config file was created as /usr/my.cnf and will be used by default by the server when you start it.You may edit this file to change server settings

[root@hostname5.6.29]# su - mysql

Last login: Mon Apr 11 14:34:00 IST 2016 on pts/0

[mysql@hostname ~]$ mysql_install_db

WARNING: Could not write to config file /usr/my-new.cnf: Permission denied

WARNING: The host 'inkrh7qa52' could not be looked up with /usr/bin/resolveip.This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames when specifying MySQL privileges !

Installing MySQL system tables...2016-04-11 14:43:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-04-11 14:43:07 0 [Note] /usr/sbin/mysqld (mysqld 5.6.29) starting as process 8620 ...

2016-04-11 14:43:07 8620 [Note] InnoDB: Using atomics to ref count buffer pool pages

2016-04-11 14:43:07 8620 [Note] InnoDB: The InnoDB memory heap is disabled

2016-04-11 14:43:07 8620 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-04-11 14:43:07 8620 [Note] InnoDB: Memory barrier is not used

2016-04-11 14:43:07 8620 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-04-11 14:43:07 8620 [Note] InnoDB: Using Linux native AIO

2016-04-11 14:43:07 8620 [Note] InnoDB: Using CPU crc32 instructions

2016-04-11 14:43:07 8620 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2016-04-11 14:43:07 8620 [Note] InnoDB: Completed initialization of buffer pool

2016-04-11 14:43:07 8620 [Note] InnoDB: Highest supported file format is Barracuda.

2016-04-11 14:43:08 8620 [Note] InnoDB: 128 rollback segment(s) are active.

2016-04-11 14:43:08 8620 [Note] InnoDB: Waiting for purge to start

2016-04-11 14:43:08 8620 [Note] InnoDB: 5.6.29 started; log sequence number 1625987

2016-04-11 14:43:08 8620 [Note] Binlog end

2016-04-11 14:43:08 8620 [Note] InnoDB: FTS optimize thread exiting.

2016-04-11 14:43:08 8620 [Note] InnoDB: Starting shutdown...

2016-04-11 14:43:09 8620 [Note] InnoDB: Shutdown completed; log sequence number 1625997

Filling help tables...2016-04-11 14:43:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-04-11 14:43:09 0 [Note] /usr/sbin/mysqld (mysqld 5.6.29) starting as process 8643 ...

2016-04-11 14:43:09 8643 [Note] InnoDB: Using atomics to ref count buffer pool pages

2016-04-11 14:43:09 8643 [Note] InnoDB: The InnoDB memory heap is disabled

2016-04-11 14:43:09 8643 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2016-04-11 14:43:09 8643 [Note] InnoDB: Memory barrier is not used

2016-04-11 14:43:09 8643 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-04-11 14:43:09 8643 [Note] InnoDB: Using Linux native AIO

2016-04-11 14:43:09 8643 [Note] InnoDB: Using CPU crc32 instructions

2016-04-11 14:43:09 8643 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2016-04-11 14:43:09 8643 [Note] InnoDB: Completed initialization of buffer pool

2016-04-11 14:43:09 8643 [Note] InnoDB: Highest supported file format is Barracuda.

2016-04-11 14:43:09 8643 [Note] InnoDB: 128 rollback segment(s) are active.

2016-04-11 14:43:09 8643 [Note] InnoDB: Waiting for purge to start

2016-04-11 14:43:10 8643 [Note] InnoDB: 5.6.29 started; log sequence number 1625997

2016-04-11 14:43:10 8643 [Note] Binlog end

2016-04-11 14:43:10 8643 [Note] InnoDB: FTS optimize thread exiting.

2016-04-11 14:43:10 8643 [Note] InnoDB: Starting shutdown...

2016-04-11 14:43:11 8643 [Note] InnoDB: Shutdown completed; log sequence number 1626007

To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands:

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h inkrh7qa52 password 'new-password'

Alternatively you can run:

/usr/bin/mysql_secure_installation

which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers.

See the manual for more instructions.You can start the MySQL daemon with:

cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl

cd mysql-test ; perl mysql-test-run.pl

Please report any problems at http://bugs.mysql.com/ The latest information about MySQL is available on the web at

http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

WARNING: Could not copy config file template /usr/share/mysql/my-default.cnf to /usr/my-new.cnf, may not have access rights to do so. You may want to copy the file manually, or create your own,

it will then be used by default by the server when you start it.

[root@hostname ~]# cat /root/.mysql_secret

# The random password set for the root user at Mon Apr 11 14:42:34 2016 (local time): yPyGCiMEDwfS_b0p

[root@hostname ~]# cp /usr/share/mysql/my-default.cnf /etc/my.cnf

[root@hostname ~]# vi /etc/my.cnf

[root@hostname ~]# cat /etc/my.cnf

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

# *** default location during install, and will be replaced if you

# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

basedir = /usr

datadir = /var/lib/mysql

port = 3306

server_id = 1

socket = /var/lib/mysql/mysql.sock

character_set_server = utf8

collation_server = utf8_general_ci

innodb_data_home_dir = /var/lib/mysql

innodb_log_group_home_dir = /var/lib/mysql

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[root@hostname ~]# service mysql restart

ERROR! MySQL server PID file could not be found!

Starting MySQL. SUCCESS!

[root@hostname ~]# service mysql status

SUCCESS! MySQL running (8960)

[root@hostname ~]# mysql -u root -p

Enter password: ------------> yPyGCiMEDwfS_b0p

Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1.Server version: 5.6.29

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;

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root'); flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

[root@hostname~]# mysql -u root -p

Enter password: ------------ >root

Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2 Server version: 5.6.29 MySQL Community Server (GPL)

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 |

| test |

+--------------------+

4 rows in set (0.00 sec)

mysql> use mysql;

Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select user,host,password from user;

+------+------------+-------------------------------------------+

| user | host | password |

+------+------------+-------------------------------------

| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |

| root | inkrh7qa52 | *1DD408DE1E6D3584AE4359831582E10A7FAA03BF |

| root | 127.0.0.1 | *1DD408DE1E6D3584AE4359831582E10A7FAA03BF |

| root | ::1 | *1DD408DE1E6D3584AE4359831582E10A7FAA03BF |

+------+------------+-------------------------------------

4 rows in set (0.00 sec)

mysql> show variables like '%port%';

+---------------------+-------+

| Variable_name | Value |

+---------------------+-------+

| innodb_support_xa | ON |

| large_files_support | ON |

| port | 3306 |

| report_host | |

| report_password | |

| report_port | 3306 |

| report_user | |

+---------------------+-------+

7 rows in set (0.00 sec)

mysql> show variables like '%char%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.01 sec)

mysql> show variables like '%collat%';

+----------------------+-----------------+

| Variable_name | Value |

+----------------------+-----------------+

| collation_connection | utf8_general_ci |

| collation_database | utf8_general_ci |

| collation_server | utf8_general_ci |

+----------------------+-----------------+

3 rows in set (0.00 sec)

mysql> show variables like '%data%';

+-------------------------------+------------------------+

| Variable_name | Value |

+-------------------------------+------------------------+

| character_set_database | utf8 |

| collation_database | utf8_general_ci |

| datadir | /var/lib/mysql/ |

| innodb_data_file_path | ibdata1:12M:autoextend |

| innodb_data_home_dir | /var/lib/mysql |

| innodb_stats_on_metadata | OFF |

| max_length_for_sort_data | 1024 |

| metadata_locks_cache_size | 1024 |

| metadata_locks_hash_instances | 8 |

| myisam_data_pointer_size | 6 |

| skip_show_database | OFF |

| updatable_views_with_limit | YES |

+-------------------------------+------------------------+

12 rows in set (0.00 sec)

mysql>

**********************************************************************

END

**********************************************************************

======================================================

RHEL 7 - DB Version 5.7.17

======================================================

[root@hostname ~]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 7.2 (Maipo)

[root@hostname ~]# groupadd -g 1020 dba1

[root@hostname /]# ls

bin data downloads home lib64 misc net proc run srv tmp var

boot dev etc lib media mnt opt root sbin sys usr

[root@hostname data]# ls -ltr

total 3840

drwxr-xr-x. 4 root root 4096 May 4 2016 mysql-connector-java-5.1.39

-rw-r--r--. 1 root root 9224 Sep 21 08:51 mysql57-community-release-el7-9.noarch.rpm

-rw-r--r--. 1 root root 3899019 Sep 21 09:58 mysql-connector-java-5.1.39.tar.gz

drwx------. 2 root root 16384 Jan 13 13:54 lost+found

[root@hostname~]# useradd -g dba1 -u 777 -d /data/mysql -m mysql

[root@hostname ~]# passwd mysql

Changing password for user mysql.

New password:

BAD PASSWORD: The password is shorter than 8 characters

Retype new password:

passwd: all authentication tokens updated successfully.

[root@hostname ~]# cd /data/mysql/

5.7/ .bash_logout .bash_profile .bashrc perl5/

[root@hostname ~]# cd /data/mysql/5.7/

[root@hostname 5.7]# pwd

/data/mysql/5.7

[root@hostname5.7]# ls -ltr

total 570452

-rw-r--r--. 1 mysql games 25037548 Nov 29 21:59 mysql-community-client-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 277812 Nov 29 21:59 mysql-community-common-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 3774276 Nov 29 21:59 mysql-community-devel-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 45474744 Nov 29 21:59 mysql-community-embedded-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 23925668 Nov 29 21:59 mysql-community-embedded-compat-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 126047424 Nov 29 22:00 mysql-community-embedded-devel-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 2237116 Nov 29 22:00 mysql-community-libs-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 2112724 Nov 29 22:00 mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 54571580 Nov 29 22:00 mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 169496800 Nov 29 22:01 mysql-community-server-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 14478292 Nov 29 22:02 mysql-community-server-minimal-5.7.17-1.el7.x86_64.rpm

-rw-r--r--. 1 mysql games 116682212 Nov 29 22:02 mysql-community-test-5.7.17-1.el7.x86_64.rpm

[root@hostname ~]# rpm -qa | grep -i maria*

mariadb-libs-5.5.44-2.el7.x86_64

[root@hostname~]# rpm -e mariadb-libs-5.5.44-2.el7.x86_64

error: Failed dependencies:

libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64

libmysqlclient.so.18()(64bit) is needed by (installed) perl-DBD-MySQL-4.023-5.el7.x86_64

libmysqlclient.so.18()(64bit) is needed by (installed) MySQL-python-1.2.3-11.el7.x86_64

libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64

libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) perl-DBD-MySQL-4.023-5.el7.x86_64

libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) MySQL-python-1.2.3-11.el7.x86_64

[root@hostname ~]# rpm -e mariadb-libs-5.5.44-2.el7.x86_64 --nodeps

warning: file /etc/my.cnf: remove failed: No such file or directory

[root@hostname~]# cd /data/mysql/5.7/

[root@hostname 5.7]# pwd

/data/mysql/5.7

[root@hostname 5.7]# ls -ltr