1) Download “V74396-01.zip” which contains:
There are two files – ASC and MD5 for “mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz”.
a: Verify MD5 checksum:
$ cat mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz.md5 f2ace50e757f1a63736e8dcbf5cfeb19 mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz $ md5sum mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz f2ace50e757f1a63736e8dcbf5cfeb19 mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz
b) Signature Checking Using GnuPG.
To obtain a copy of our public GPG build key by copying or download from http://pgp.mit.edu/( The key is” mysql-build@oss.oracle.com”) to file mysql_pubkey.asc.
To import the build key into your personal public GPG keyring:
[root@racnote1 .gnupg]# gpg --import mysql_pubkey.asc gpg: keyring `/root/.gnupg/secring.gpg' created gpg: keyring `/root/.gnupg/pubring.gpg' created gpg: /root/.gnupg/trustdb.gpg: trustdb created gpg: key 5072E1F5: public key "MySQL Release Engineering <mysql-build@oss.oracle.com>" imported gpg: Total number processed: 1 gpg: imported: 1 gpg: no ultimately trusted keys found [root@racnote1 .gnupg]# ls -ltr total 28 -rw-r--r--. 1 root root 5968 Mar 24 12:02 mysql_pubkey.asc -rw-------. 1 root root 0 Mar 24 13:07 secring.gpg -rw-------. 1 root root 4434 Mar 24 13:07 pubring.gpg~ -rw-------. 1 root root 4434 Mar 24 13:07 pubring.gpg -rw-------. 1 root root 1200 Mar 24 13:07 trustdb.gpg
To verify the signature for the distribution file:
[root@racnote1 Patches]# gpg --verify mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz.asc gpg: Signature made Fri 30 Jan 2015 17:49:39 AEDT using DSA key ID 5072E1F5 gpg: Good signature from "MySQL Release Engineering <mysql-build@oss.oracle.com>" gpg: WARNING: This key is not certified with a trusted signature! gpg: There is no indication that the signature belongs to the owner. Primary key fingerprint: A4A9 4068 76FC BD3C 4567 70C8 8C71 8D3B 5072 E1F5
2) Remove the previous MySQL installation.
a. Stop MySQL server
$service mysqld stop
b. Remove mysql-community-server and RPM packages.
[root@racnote1 Patches]# yum remove mysql-community-server Loaded plugins: langpacks Resolving Dependencies --> Running transaction check ---> Package mysql-community-server.x86_64 0:5.6.23-3.el7 will be erased --> Processing Dependency: mysql-compat-server for package: akonadi-mysql-1.9.2-4.0.1.el7.x86_64 --> Running transaction check ---> Package akonadi-mysql.x86_64 0:1.9.2-4.0.1.el7 will be erased --> Finished Dependency Resolution adobe-linux-x86_64 | 951 B 00:00:00 mysql-connectors-community/x86_64 | 2.5 kB 00:00:00 mysql-tools-community/x86_64 | 2.5 kB 00:00:00 mysql56-community/x86_64 | 2.5 kB 00:00:00 ol7_UEKR3/x86_64 | 1.2 kB 00:00:00 ol7_latest/x86_64 | 1.4 kB 00:00:00 ol7_latest/x86_64/updateinfo | 349 kB 00:00:00 ol7_latest/x86_64/primary | 8.4 MB 00:00:10 Dependencies Resolved ====================================================================================================================================================== Package Arch Version Repository Size ====================================================================================================================================================== Removing: mysql-community-server x86_64 5.6.23-3.el7 @mysql56-community 244 M Removing for dependencies: akonadi-mysql x86_64 1.9.2-4.0.1.el7 @ol7_latest 9.6 k Transaction Summary ====================================================================================================================================================== Remove 1 Package (+1 Dependent package) Installed size: 244 M Is this ok [y/N]: Y Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Erasing : akonadi-mysql-1.9.2-4.0.1.el7.x86_64 1/2 Erasing : mysql-community-server-5.6.23-3.el7.x86_64 2/2 Verifying : mysql-community-server-5.6.23-3.el7.x86_64 1/2 Verifying : akonadi-mysql-1.9.2-4.0.1.el7.x86_64 2/2 Removed: mysql-community-server.x86_64 0:5.6.23-3.el7 Dependency Removed: akonadi-mysql.x86_64 0:1.9.2-4.0.1.el7 Complete! [root@racnote1 Patches]# rpm -qa |grep -i mysql mysql-community-client-5.6.23-3.el7.x86_64 perl-DBD-MySQL-4.023-5.0.1.el7.x86_64 qt-mysql-4.8.5-8.0.1.el7.x86_64 mysql-community-common-5.6.23-3.el7.x86_64 mysql-community-release-el7-5.noarch mysql-community-libs-5.6.23-3.el7.x86_64 [root@racnote1 Patches]# yum remove mysql-community-common-5.6.23-3.el7.x86_64 Loaded plugins: langpacks Resolving Dependencies --> Running transaction check ---> Package mysql-community-common.x86_64 0:5.6.23-3.el7 will be erased --> Processing Dependency: mysql-community-common(x86-64) = 5.6.23-3.el7 for package: mysql-community-libs-5.6.23-3.el7.x86_64 --> Running transaction check ---> Package mysql-community-libs.x86_64 0:5.6.23-3.el7 will be erased --> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-5.0.1.el7.x86_64 --> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 1:net-snmp-5.7.2-18.el7.x86_64 --> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 1:qt-mysql-4.8.5-8.0.1.el7.x86_64 --> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.0.1.el7.x86_64 --> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-5.0.1.el7.x86_64 --> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 1:qt-mysql-4.8.5-8.0.1.el7.x86_64 --> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.0.1.el7.x86_64 --> Processing Dependency: mysql-community-libs(x86-64) = 5.6.23-3.el7 for package: mysql-community-client-5.6.23-3.el7.x86_64 --> Processing Dependency: mysql-libs for package: 1:net-snmp-5.7.2-18.el7.x86_64 --> Running transaction check ---> Package mysql-community-client.x86_64 0:5.6.23-3.el7 will be erased ---> Package net-snmp.x86_64 1:5.7.2-18.el7 will be erased ---> Package perl-DBD-MySQL.x86_64 0:4.023-5.0.1.el7 will be erased ---> Package postfix.x86_64 2:2.10.1-6.0.1.el7 will be erased ---> Package qt-mysql.x86_64 1:4.8.5-8.0.1.el7 will be erased --> Finished Dependency Resolution Dependencies Resolved ====================================================================================================================================================== Package Arch Version Repository Size ====================================================================================================================================================== Removing: mysql-community-common x86_64 5.6.23-3.el7 @mysql56-community 2.1 M Removing for dependencies: mysql-community-client x86_64 5.6.23-3.el7 @mysql56-community 87 M mysql-community-libs x86_64 5.6.23-3.el7 @mysql56-community 9.1 M net-snmp x86_64 1:5.7.2-18.el7 @anaconda/7.0 850 k perl-DBD-MySQL x86_64 4.023-5.0.1.el7 @ol7_latest 323 k postfix x86_64 2:2.10.1-6.0.1.el7 @ol7_latest 12 M qt-mysql x86_64 1:4.8.5-8.0.1.el7 @ol7_latest 74 k Transaction Summary ====================================================================================================================================================== Remove 1 Package (+6 Dependent packages) Installed size: 112 M Is this ok [y/N]: Y Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Erasing : 1:net-snmp-5.7.2-18.el7.x86_64 1/7 Erasing : 2:postfix-2.10.1-6.0.1.el7.x86_64 2/7 Erasing : 1:qt-mysql-4.8.5-8.0.1.el7.x86_64 3/7 Erasing : mysql-community-client-5.6.23-3.el7.x86_64 4/7 Erasing : perl-DBD-MySQL-4.023-5.0.1.el7.x86_64 5/7 Erasing : mysql-community-libs-5.6.23-3.el7.x86_64 6/7 Erasing : mysql-community-common-5.6.23-3.el7.x86_64 7/7 Verifying : mysql-community-libs-5.6.23-3.el7.x86_64 1/7 Verifying : perl-DBD-MySQL-4.023-5.0.1.el7.x86_64 2/7 Verifying : mysql-community-client-5.6.23-3.el7.x86_64 3/7 Verifying : 1:qt-mysql-4.8.5-8.0.1.el7.x86_64 4/7 Verifying : 2:postfix-2.10.1-6.0.1.el7.x86_64 5/7 Verifying : 1:net-snmp-5.7.2-18.el7.x86_64 6/7 Verifying : mysql-community-common-5.6.23-3.el7.x86_64 7/7 Removed: mysql-community-common.x86_64 0:5.6.23-3.el7 Dependency Removed: mysql-community-client.x86_64 0:5.6.23-3.el7 mysql-community-libs.x86_64 0:5.6.23-3.el7 net-snmp.x86_64 1:5.7.2-18.el7 perl-DBD-MySQL.x86_64 0:4.023-5.0.1.el7 postfix.x86_64 2:2.10.1-6.0.1.el7 qt-mysql.x86_64 1:4.8.5-8.0.1.el7 Complete! [root@racnote1 Patches]# rpm -qa |grep -i mysql mysql-community-release-el7-5.noarch
c. Stopping YUM from receiving MySQL packages from Third-Party, Nonnative Repositories.
# view /etc/yum.repos.d/mysql-community.repo
# yum-config-manager --disable mysql-tools-community # yum-config-manager --disable mysql-connectors-community # yum-config-manager --disable mysql56-community
d. Check and delete /etc/my.cnf or /etc/mysql files if any.
3) Install MySQL by unpacking the distribution.
#cd /usr/local #tar zxvf /media/sf_Oracle12102/Patches/mysql-advanced-5.6.23-linux-glibc2.5-x86_64.tar.gz # ln -s mysql-advanced-5.6.23-linux-glibc2.5-x86_64 mysql # cd mysql # chown -R mysql . # chgrp -R mysql . #scripts/mysql_install_db --user=mysql # chown -R root . #chown -R mysql data # bin/mysqld_safe --user=mysql & [1] 3492 [root@racnote1 mysql]# 150324 16:33:40 mysqld_safe Logging to '/usr/local/mysql/data/racnote1.err'. 150324 16:33:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data #cp support-files/mysql.server /etc/init.d/mysql.server MySQL Installation Layout for Generic Unix/Linux Binary Package
| Directory | Contents of Directory |
|---|---|
bin,scripts | mysqld server, client and utility programs |
data | Log files, databases |
docs | MySQL manual in Info format |
man | Unix manual pages |
include | Include (header) files |
lib | Libraries |
share | Miscellaneous support files, including error messages, sample configuration files, SQL for database installation |
sql-bench | Benchmarks |
4) Perform Post-installation Set-up as per installation doc.
Make DBA Life Easy 
Reblogged this on WatsupDBAz.
LikeLike