Open a terminal and do the following:
# rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
# nano /etc/yum.repos.d/remi.repo
# yum -y update mysql*
# rpm -qa | grep mysql
# rpm -Uhv http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
# yum install mysql-community-server
Example:
[root@localhost ~]# rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
Retrieving https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
Preparing... ########################################### [100%]
package epel-release-6-8.noarch is already installed
[root@localhost ~]# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
Retrieving http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
warning: /var/tmp/rpm-tmp.xhdHau: Header V4 DSA/SHA1 Signature, key ID 00f97f56: NOKEY
Preparing... ########################################### [100%]
1:remi-release ########################################### [100%]
[root@localhost ~]# nano /etc/yum.repos.d/remi.repo
[root@localhost ~]# yum -y update mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: centos.excellmedia.net
* epel: del-repos.extreme-ix.org
* extras: centos.excellmedia.net
* remi-safe: mirror.innosol.asia
* updates: centos.excellmedia.net
remi-safe | 3.0 kB 00:00
http://mirror.innosol.asia/remi/enterprise/6/safe/x86_64/repodata/fca98567264e38467103c52a8b12ed06cb0ee1b2215c24ecc24be0012ee1ed0d-primary.sqlite.bz2: [Errno 12] Timeout on http://mirror.innosol.asia/remi/enterprise/6/safe/x86_64/repodata/fca98567264e38467103c52a8b12ed06cb0ee1b2215c24ecc24be0012ee1ed0d-primary.sqlite.bz2: (28, 'Operation too slow. Less than 1 bytes/sec transfered the last 30 seconds')
Trying other mirror.
remi-safe/primary_db | 1.1 MB 00:01
Setting up Update Process
Examining mysql-community-release-el6-5.noarch.rpm: mysql-community-release-el6-5.noarch
Package mysql-community-release not installed, cannot update it. Run yum install to install it instead.
No Packages marked for Update
[root@localhost ~]# rpm -qa | grep mysql
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64
php-mysql-5.3.3-49.el6.x86_64
mysql-server-5.1.73-8.el6_8.x86_64
[root@localhost ~]# rpm -Uhv http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Retrieving http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Preparing... ########################################### [100%]
1:mysql-community-release########################################### [100%]
[root@localhost ~]# yum install mysql-community-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: centos.excellmedia.net
* epel: del-repos.extreme-ix.org
* extras: centos.excellmedia.net
* remi-safe: ftp.riken.jp
* updates: centos.excellmedia.net
mysql-connectors-community | 2.5 kB 00:00
mysql-connectors-community/primary_db | 27 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql-tools-community/primary_db | 45 kB 00:00
mysql56-community | 2.5 kB 00:00
mysql56-community/primary_db | 241 kB 00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.42-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.42-2.el6 for package: mysql-community-server-5.6.42-2.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.42-2.el6.x86_64
---> Package mysql-server.x86_64 0:5.1.73-8.el6_8 will be obsoleted
--> Running transaction check
---> Package mysql.x86_64 0:5.1.73-8.el6_8 will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.42-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.42-2.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.6.42-2.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.42-2.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.1.73-8.el6_8 will be obsoleted
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: php-mysql-5.3.3-49.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php-mysql-5.3.3-49.el6.x86_64
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.6.42-2.el6 will be obsoleting
---> Package postfix.x86_64 2:2.6.6-2.2.el6_1 will be updated
---> Package postfix.x86_64 2:2.6.6-8.el6 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-community-client x86_64 5.6.42-2.el6 mysql56-community 18 M
replacing mysql.x86_64 5.1.73-8.el6_8
mysql-community-libs x86_64 5.6.42-2.el6 mysql56-community 1.9 M
replacing mysql-libs.x86_64 5.1.73-8.el6_8
mysql-community-libs-compat x86_64 5.6.42-2.el6 mysql56-community 1.6 M
replacing mysql-libs.x86_64 5.1.73-8.el6_8
mysql-community-server x86_64 5.6.42-2.el6 mysql56-community 55 M
replacing mysql-server.x86_64 5.1.73-8.el6_8
Installing for dependencies:
mysql-community-common x86_64 5.6.42-2.el6 mysql56-community 308 k
Updating for dependencies:
postfix x86_64 2:2.6.6-8.el6 base 2.0 M
Transaction Summary
================================================================================
Install 5 Package(s)
Upgrade 1 Package(s)
Total download size: 78 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): mysql-community-client-5.6.42-2.el6.x86_64.rpm | 18 MB 00:19
(2/6): mysql-community-common-5.6.42-2.el6.x86_64.rpm | 308 kB 00:00
(3/6): mysql-community-libs-5.6.42-2.el6.x86_64.rpm | 1.9 MB 00:03
(4/6): mysql-community-libs-compat-5.6.42-2.el6.x86_64.r | 1.6 MB 00:02
(5/6): mysql-community-server-5.6.42-2.el6.x86_64.rpm | 55 MB 01:52
(6/6): postfix-2.6.6-8.el6.x86_64.rpm | 2.0 MB 00:02
--------------------------------------------------------------------------------
Total 546 kB/s | 78 MB 02:27
warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
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>
Package: mysql-community-release-el6-5.noarch (installed)
From : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : mysql-community-common-5.6.42-2.el6.x86_64 1/10
Installing : mysql-community-libs-5.6.42-2.el6.x86_64 2/10
Installing : mysql-community-client-5.6.42-2.el6.x86_64 3/10
Installing : mysql-community-libs-compat-5.6.42-2.el6.x86_64 4/10
Updating : 2:postfix-2.6.6-8.el6.x86_64 5/10
Installing : mysql-community-server-5.6.42-2.el6.x86_64 6/10
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Erasing : mysql-server-5.1.73-8.el6_8.x86_64 7/10
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Erasing : mysql-5.1.73-8.el6_8.x86_64 8/10
Cleanup : 2:postfix-2.6.6-2.2.el6_1.x86_64 9/10
Erasing : mysql-libs-5.1.73-8.el6_8.x86_64 10/10
Verifying : mysql-community-client-5.6.42-2.el6.x86_64 1/10
Verifying : mysql-community-libs-compat-5.6.42-2.el6.x86_64 2/10
Verifying : 2:postfix-2.6.6-8.el6.x86_64 3/10
Verifying : mysql-community-libs-5.6.42-2.el6.x86_64 4/10
Verifying : mysql-community-common-5.6.42-2.el6.x86_64 5/10
Verifying : mysql-community-server-5.6.42-2.el6.x86_64 6/10
Verifying : 2:postfix-2.6.6-2.2.el6_1.x86_64 7/10
Verifying : mysql-server-5.1.73-8.el6_8.x86_64 8/10
Verifying : mysql-5.1.73-8.el6_8.x86_64 9/10
Verifying : mysql-libs-5.1.73-8.el6_8.x86_64 10/10
Installed:
mysql-community-client.x86_64 0:5.6.42-2.el6
mysql-community-libs.x86_64 0:5.6.42-2.el6
mysql-community-libs-compat.x86_64 0:5.6.42-2.el6
mysql-community-server.x86_64 0:5.6.42-2.el6
Dependency Installed:
mysql-community-common.x86_64 0:5.6.42-2.el6
Dependency Updated:
postfix.x86_64 2:2.6.6-8.el6
Replaced:
mysql.x86_64 0:5.1.73-8.el6_8 mysql-libs.x86_64 0:5.1.73-8.el6_8
mysql-server.x86_64 0:5.1.73-8.el6_8
Complete!
[root@localhost ~]#
***********************
I upgrade mysql 5.1 to 5.6 receive an error message..
MySQL Daemon failed to start.
Solution:
https://universalmaple.blogspot.com/2018/11/mysql-daemon-failed-to-start-centos-6.html
[root@localhost ~]# rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
Retrieving https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
Preparing... ########################################### [100%]
package epel-release-6-8.noarch is already installed
[root@localhost ~]# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
Retrieving http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
warning: /var/tmp/rpm-tmp.xhdHau: Header V4 DSA/SHA1 Signature, key ID 00f97f56: NOKEY
Preparing... ########################################### [100%]
1:remi-release ########################################### [100%]
[root@localhost ~]# nano /etc/yum.repos.d/remi.repo
[root@localhost ~]# yum -y update mysql*
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: centos.excellmedia.net
* epel: del-repos.extreme-ix.org
* extras: centos.excellmedia.net
* remi-safe: mirror.innosol.asia
* updates: centos.excellmedia.net
remi-safe | 3.0 kB 00:00
http://mirror.innosol.asia/remi/enterprise/6/safe/x86_64/repodata/fca98567264e38467103c52a8b12ed06cb0ee1b2215c24ecc24be0012ee1ed0d-primary.sqlite.bz2: [Errno 12] Timeout on http://mirror.innosol.asia/remi/enterprise/6/safe/x86_64/repodata/fca98567264e38467103c52a8b12ed06cb0ee1b2215c24ecc24be0012ee1ed0d-primary.sqlite.bz2: (28, 'Operation too slow. Less than 1 bytes/sec transfered the last 30 seconds')
Trying other mirror.
remi-safe/primary_db | 1.1 MB 00:01
Setting up Update Process
Examining mysql-community-release-el6-5.noarch.rpm: mysql-community-release-el6-5.noarch
Package mysql-community-release not installed, cannot update it. Run yum install to install it instead.
No Packages marked for Update
[root@localhost ~]# rpm -qa | grep mysql
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64
php-mysql-5.3.3-49.el6.x86_64
mysql-server-5.1.73-8.el6_8.x86_64
[root@localhost ~]# rpm -Uhv http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Retrieving http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Preparing... ########################################### [100%]
1:mysql-community-release########################################### [100%]
[root@localhost ~]# yum install mysql-community-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
* base: centos.excellmedia.net
* epel: del-repos.extreme-ix.org
* extras: centos.excellmedia.net
* remi-safe: ftp.riken.jp
* updates: centos.excellmedia.net
mysql-connectors-community | 2.5 kB 00:00
mysql-connectors-community/primary_db | 27 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql-tools-community/primary_db | 45 kB 00:00
mysql56-community | 2.5 kB 00:00
mysql56-community/primary_db | 241 kB 00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.6.42-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.42-2.el6 for package: mysql-community-server-5.6.42-2.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 5.6.10 for package: mysql-community-server-5.6.42-2.el6.x86_64
---> Package mysql-server.x86_64 0:5.1.73-8.el6_8 will be obsoleted
--> Running transaction check
---> Package mysql.x86_64 0:5.1.73-8.el6_8 will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.42-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-libs(x86-64) >= 5.6.10 for package: mysql-community-client-5.6.42-2.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.6.42-2.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.6.42-2.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.1.73-8.el6_8 will be obsoleted
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: php-mysql-5.3.3-49.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-2.2.el6_1.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: php-mysql-5.3.3-49.el6.x86_64
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:5.6.42-2.el6 will be obsoleting
---> Package postfix.x86_64 2:2.6.6-2.2.el6_1 will be updated
---> Package postfix.x86_64 2:2.6.6-8.el6 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
mysql-community-client x86_64 5.6.42-2.el6 mysql56-community 18 M
replacing mysql.x86_64 5.1.73-8.el6_8
mysql-community-libs x86_64 5.6.42-2.el6 mysql56-community 1.9 M
replacing mysql-libs.x86_64 5.1.73-8.el6_8
mysql-community-libs-compat x86_64 5.6.42-2.el6 mysql56-community 1.6 M
replacing mysql-libs.x86_64 5.1.73-8.el6_8
mysql-community-server x86_64 5.6.42-2.el6 mysql56-community 55 M
replacing mysql-server.x86_64 5.1.73-8.el6_8
Installing for dependencies:
mysql-community-common x86_64 5.6.42-2.el6 mysql56-community 308 k
Updating for dependencies:
postfix x86_64 2:2.6.6-8.el6 base 2.0 M
Transaction Summary
================================================================================
Install 5 Package(s)
Upgrade 1 Package(s)
Total download size: 78 M
Is this ok [y/N]: y
Downloading Packages:
(1/6): mysql-community-client-5.6.42-2.el6.x86_64.rpm | 18 MB 00:19
(2/6): mysql-community-common-5.6.42-2.el6.x86_64.rpm | 308 kB 00:00
(3/6): mysql-community-libs-5.6.42-2.el6.x86_64.rpm | 1.9 MB 00:03
(4/6): mysql-community-libs-compat-5.6.42-2.el6.x86_64.r | 1.6 MB 00:02
(5/6): mysql-community-server-5.6.42-2.el6.x86_64.rpm | 55 MB 01:52
(6/6): postfix-2.6.6-8.el6.x86_64.rpm | 2.0 MB 00:02
--------------------------------------------------------------------------------
Total 546 kB/s | 78 MB 02:27
warning: rpmts_HdrFromFdno: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
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>
Package: mysql-community-release-el6-5.noarch (installed)
From : file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
Installing : mysql-community-common-5.6.42-2.el6.x86_64 1/10
Installing : mysql-community-libs-5.6.42-2.el6.x86_64 2/10
Installing : mysql-community-client-5.6.42-2.el6.x86_64 3/10
Installing : mysql-community-libs-compat-5.6.42-2.el6.x86_64 4/10
Updating : 2:postfix-2.6.6-8.el6.x86_64 5/10
Installing : mysql-community-server-5.6.42-2.el6.x86_64 6/10
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Erasing : mysql-server-5.1.73-8.el6_8.x86_64 7/10
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Erasing : mysql-5.1.73-8.el6_8.x86_64 8/10
Cleanup : 2:postfix-2.6.6-2.2.el6_1.x86_64 9/10
Erasing : mysql-libs-5.1.73-8.el6_8.x86_64 10/10
Verifying : mysql-community-client-5.6.42-2.el6.x86_64 1/10
Verifying : mysql-community-libs-compat-5.6.42-2.el6.x86_64 2/10
Verifying : 2:postfix-2.6.6-8.el6.x86_64 3/10
Verifying : mysql-community-libs-5.6.42-2.el6.x86_64 4/10
Verifying : mysql-community-common-5.6.42-2.el6.x86_64 5/10
Verifying : mysql-community-server-5.6.42-2.el6.x86_64 6/10
Verifying : 2:postfix-2.6.6-2.2.el6_1.x86_64 7/10
Verifying : mysql-server-5.1.73-8.el6_8.x86_64 8/10
Verifying : mysql-5.1.73-8.el6_8.x86_64 9/10
Verifying : mysql-libs-5.1.73-8.el6_8.x86_64 10/10
Installed:
mysql-community-client.x86_64 0:5.6.42-2.el6
mysql-community-libs.x86_64 0:5.6.42-2.el6
mysql-community-libs-compat.x86_64 0:5.6.42-2.el6
mysql-community-server.x86_64 0:5.6.42-2.el6
Dependency Installed:
mysql-community-common.x86_64 0:5.6.42-2.el6
Dependency Updated:
postfix.x86_64 2:2.6.6-8.el6
Replaced:
mysql.x86_64 0:5.1.73-8.el6_8 mysql-libs.x86_64 0:5.1.73-8.el6_8
mysql-server.x86_64 0:5.1.73-8.el6_8
Complete!
[root@localhost ~]#
***********************
I upgrade mysql 5.1 to 5.6 receive an error message..
MySQL Daemon failed to start.
Solution:
https://universalmaple.blogspot.com/2018/11/mysql-daemon-failed-to-start-centos-6.html
0 Comments