Topic: MySQL 5.6.19
Hi Remi,
Current Generally Available Release of MySQL is 5.6.19 (with a lot of interesting feature, such as EXPLAIN UPDATE).
Do you plan to make it available in your great repo?
Thanks!
You are not logged in. Please login or register.
Please STOP WAR NOW! | |
For proper configuration and installation, please use the Configuration Wizard |
Versions: PHP ≤ 8.0 is EOL - PHP 8.1.27 - PHP 8.2.17 - PHP 8.2.18RC1 - PHP 8.3.4 - PHP 8.3.5RC1
More information: #remirepo IRC channel - Twitter: @RemiRepository - Discord server
Remi's RPM repository - Forum → User support → MySQL 5.6.19
Hi Remi,
Current Generally Available Release of MySQL is 5.6.19 (with a lot of interesting feature, such as EXPLAIN UPDATE).
Do you plan to make it available in your great repo?
Thanks!
No, I don't plan to provides update to MySQL 5.6.
I prefer to concentrate myself on PHP stuff, and PHP doesn't use libmysql anymore.
For database I recommend to use RHSCL which provides mysql 5.5 and mariadb 5.5 (and perhaps, in a near future, mysql 5.6, mariadb 10.0).
Ok, thanks!
Meanwhile, I discovered that MySQL can be installed from an official repo http://dev.mysql.com/doc/refman/5.6/en/ … -repo.html
For me this is golden: any specific reasoning against it?
I have absolutely no confidence with Oracle packaging.
Unfortunately it doesn't work.
I rely on remi for PHP:
yum --enablerepo=remi install php php-mysql
But when I try to install mysql-community-server from the official repo...
yum --enablerepo='mysql*-community*,base' install mysql-community-server
I get this:
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.prometeus.net
* epel: mirror.proserve.nl
* extras: mirrors.prometeus.net
* remi: remirpm.mirror.gymkl.ch
* updates: mirrors.prometeus.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:5.7.4-0.3.m14.el6 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 5.7.4-0.3.m14.el6 for package: mysql-community-server-5.7.4-0.3.m14.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) = 5.7.4-0.3.m14.el6 for package: mysql-community-server-5.7.4-0.3.m14.el6.x86_64
--> Processing Dependency: perl(DBI) for package: mysql-community-server-5.7.4-0.3.m14.el6.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:5.7.4-0.3.m14.el6 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) = 5.7.4-0.3.m14.el6 for package: mysql-community-client-5.7.4-0.3.m14.el6.x86_64
---> Package mysql-community-common.x86_64 0:5.7.4-0.3.m14.el6 will be installed
---> Package perl-DBI.x86_64 0:1.609-4.el6 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:5.7.4-0.3.m14.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.38-1.el6.remi will be obsoleted
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: php-mysql-5.4.31-1.el6.remi.x86_64
--> Finished Dependency Resolution
Error: Package: php-mysql-5.4.31-1.el6.remi.x86_64 (@remi)
Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
Removing: mysql-libs-5.5.38-1.el6.remi.x86_64 (@remi)
libmysqlclient.so.18(libmysqlclient_16)(64bit)
Obsoleted By: mysql-community-libs-5.7.4-0.3.m14.el6.x86_64 (mysql57-community-dmr)
Not found
Available: mysql-libs-5.5.37-1.el6.remi.x86_64 (remi)
libmysqlclient.so.18(libmysqlclient_16)(64bit)
Available: mysql-libs-5.1.71-1.el6.i686 (base)
Not found
Available: mysql-libs-5.1.73-3.el6_5.i686 (updates)
Not found
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
Could you please give me a hand? I would understand if not :-)
Use php-mysqlnd instead of php-mysql.
Notice: php 5.5 and 5.6 doesn't provides php-mysql (which rely on libmysqlclient), but only php-mysqlnd.
It works! Once again you saved the day! Thank you very, very much!
[root@test tmp]# yum clean
Loaded plugins: downloadonly, fastestmirror, refresh-packagekit, security
Error: clean requires an option: headers, packages, metadata, dbcache, plugins, expire-cache, rpmdb, all
[root@test tmp]# yum clean all
Loaded plugins: downloadonly, fastestmirror, refresh-packagekit, security
Cleaning repos: base elasticsearch-1.3 epel extras mysql-connectors-community mysql-tools-community mysql56-community remi remi-php55 updates
Cleaning up Everything
Cleaning up list of fastest mirrors
[root@test tmp]# yum update -y
Loaded plugins: downloadonly, fastestmirror, refresh-packagekit, security
Determining fastest mirrors
epel/metalink | 28 kB 00:00
* base: mirrors.coreix.net
* epel: epel.check-update.co.uk
* extras: mirror.econdc.com
* remi: remi.check-update.co.uk
* remi-php55: remi.check-update.co.uk
* updates: mirrors.coreix.net
base | 3.7 kB 00:00
base/primary_db | 4.4 MB 00:02
elasticsearch-1.3 | 2.5 kB 00:00
elasticsearch-1.3/primary_db | 3.8 kB 00:00
epel | 4.4 kB 00:00
epel/primary_db | 6.3 MB 00:01
extras | 3.3 kB 00:00
extras/primary_db | 19 kB 00:00
mysql-connectors-community | 2.5 kB 00:00
mysql-connectors-community/primary_db | 7.0 kB 00:00
mysql-tools-community | 2.5 kB 00:00
mysql-tools-community/primary_db | 16 kB 00:00
mysql56-community | 2.5 kB 00:00
mysql56-community/primary_db | 59 kB 00:00
remi | 2.9 kB 00:00
remi/primary_db | 1.0 MB 00:00
remi-php55 | 2.9 kB 00:00
remi-php55/primary_db | 164 kB 00:00
updates | 3.4 kB 00:00
updates/primary_db | 5.4 MB 00:02
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.5.39-1.el6.remi will be obsoleted
---> Package mysql-community-client.x86_64 0:5.6.21-2.el6 will be obsoleting
---> Package mysql-community-libs.x86_64 0:5.6.21-2.el6 will be obsoleting
--> Processing Dependency: mysql-community-common(x86-64) = 5.6.21-2.el6 for package: mysql-community-libs-5.6.21-2.el6.x86_64
---> Package mysql-community-libs-compat.x86_64 0:5.6.21-2.el6 will be obsoleting
---> Package mysql-community-server.x86_64 0:5.6.21-2.el6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.39-1.el6.remi will be obsoleted
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be obsoleted
--> Running transaction check
---> Package mysql-community-common.x86_64 0:5.6.21-2.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=====================================================================================================================================================================================================
Package Arch Version Repository Size
=====================================================================================================================================================================================================
Installing:
mysql-community-client x86_64 5.6.21-2.el6 mysql56-community 18 M
replacing mysql.x86_64 5.5.39-1.el6.remi
mysql-community-libs x86_64 5.6.21-2.el6 mysql56-community 1.9 M
replacing mysql-libs.x86_64 5.5.39-1.el6.remi
mysql-community-libs-compat x86_64 5.6.21-2.el6 mysql56-community 1.6 M
replacing mysql-libs.x86_64 5.5.39-1.el6.remi
mysql-community-server x86_64 5.6.21-2.el6 mysql56-community 53 M
replacing mysql-server.x86_64 5.5.39-1.el6.remi
Installing for dependencies:
mysql-community-common x86_64 5.6.21-2.el6 mysql56-community 299 k
Transaction Summary
=====================================================================================================================================================================================================
Install 5 Package(s)
Total download size: 74 M
Downloading Packages:
(1/5): mysql-community-client-5.6.21-2.el6.x86_64.rpm | 18 MB 00:04
(2/5): mysql-community-common-5.6.21-2.el6.x86_64.rpm | 299 kB 00:00
(3/5): mysql-community-libs-5.6.21-2.el6.x86_64.rpm | 1.9 MB 00:00
(4/5): mysql-community-libs-compat-5.6.21-2.el6.x86_64.rpm | 1.6 MB 00:00
(5/5): mysql-community-server-5.6.21-2.el6.x86_64.rpm | 53 MB 00:11
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 4.5 MB/s | 74 MB 00:16
Running rpm_check_debug
Running Transaction Test
Transaction Check Error:
file /usr/lib64/mysql/libmysqlclient.so.16.0.0 from install of mysql-community-libs-compat-5.6.21-2.el6.x86_64 conflicts with file from package compat-mysql51-5.1.54-1.el6.remi.x86_64
file /usr/lib64/mysql/libmysqlclient_r.so.16.0.0 from install of mysql-community-libs-compat-5.6.21-2.el6.x86_64 conflicts with file from package compat-mysql51-5.1.54-1.el6.remi.x86_64
Error Summary
-------------
I guess I need to remove that library? But doing so looks a little scary... as it removes mysql server and many other things!
[root@test tmp]# yum remove compat-mysql51
Loaded plugins: downloadonly, fastestmirror, refresh-packagekit, security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package compat-mysql51.x86_64 0:5.1.54-1.el6.remi will be erased
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16()(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: 2:postfix-2.6.6-6.el6_5.x86_64
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.013-3.el6.x86_64
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.013-3.el6 will be erased
--> Processing Dependency: perl(DBD::mysql) >= 1.0 for package: percona-toolkit-2.2.6-1.noarch
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.5.39-1.el6.remi.x86_64
---> Package postfix.x86_64 2:2.6.6-6.el6_5 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.x86_64
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-12.el6.x86_64
--> Running transaction check
---> Package cronie.x86_64 0:1.4.4-12.el6 will be erased
--> Processing Dependency: vixie-cron for package: yum-cron-3.2.29-43.el6.centos.noarch
--> Processing Dependency: cronie = 1.4.4-12.el6 for package: cronie-anacron-1.4.4-12.el6.x86_64
---> Package mysql-server.x86_64 0:5.5.39-1.el6.remi will be erased
---> Package percona-toolkit.noarch 0:2.2.6-1 will be erased
---> Package redhat-lsb-core.x86_64 0:4.0-7.el6.centos will be erased
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-printing-4.0-7.el6.centos.x86_64
--> Processing Dependency: redhat-lsb-core(x86-64) = 4.0 for package: redhat-lsb-graphics-4.0-7.el6.centos.x86_64
--> Running transaction check
---> Package cronie-anacron.x86_64 0:1.4.4-12.el6 will be erased
---> Package redhat-lsb-graphics.x86_64 0:4.0-7.el6.centos will be erased
---> Package redhat-lsb-printing.x86_64 0:4.0-7.el6.centos will be erased
---> Package yum-cron.noarch 0:3.2.29-43.el6.centos will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-22.el6_5.1.x86_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.x86_64 0:9.0.4-22.el6_5.1 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
=====================================================================================================================================================================================================
Package Arch Version Repository Size
=====================================================================================================================================================================================================
Removing:
compat-mysql51 x86_64 5.1.54-1.el6.remi @remi 4.2 M
Removing for dependencies:
cronie x86_64 1.4.4-12.el6 @base 174 k
cronie-anacron x86_64 1.4.4-12.el6 @base 43 k
crontabs noarch 1.10-33.el6 @base/$releasever 2.4 k
mysql-server x86_64 5.5.39-1.el6.remi @remi 45 M
percona-toolkit noarch 2.2.6-1 @percona 5.8 M
perl-DBD-MySQL x86_64 4.013-3.el6 @base 338 k
postfix x86_64 2:2.6.6-6.el6_5 @updates 9.7 M
redhat-lsb-core x86_64 4.0-7.el6.centos @base/$releasever 22 k
redhat-lsb-graphics x86_64 4.0-7.el6.centos @base/$releasever 0.0
redhat-lsb-printing x86_64 4.0-7.el6.centos @base/$releasever 0.0
sysstat x86_64 9.0.4-22.el6_5.1 @updates 823 k
yum-cron noarch 3.2.29-43.el6.centos @updates 28 k
Transaction Summary
=====================================================================================================================================================================================================
Remove 13 Package(s)
Installed size: 66 M
Is this ok [y/N]: n
Exiting on user Command
Any help gratefully received, thank you.
This is an issue with a third party repo I'm not aware of (and don't want to be...)
compat-mysql51 is a compatibility library for base system.
So you have to find how to provide this library with the repo you are using.
So better to ask them.
Sorry, but I can't help for packages not from my repo.
perhaps you should try
$ yum shell
> remove compat-mysql51
> install mysql-community-libs-compat
> run
THANK YOU!
That worked a treat.
Remi's RPM repository - Forum → User support → MySQL 5.6.19
Generated in 0.027 seconds (92% PHP - 8% DB) with 11 queries
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 2 official extensions. Copyright © 2003–2009 PunBB.