transaction check error – mysql-community-libs-compat conflicts with file from package compat-mysql51

While upgrading MySQL server on centos 6 from 5.5 to 5.7 you may encounter following error:

[code]
Transaction Check Error:
file /usr/lib64/mysql/libmysqlclient.so.16.0.0 from install of mysql-community-libs-compat-5.7.11-1.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.7.11-1.el6.x86_64 conflicts with file from package compat-mysql51-5.1.54-1.el6.remi.x86_64
[/code]

It can be resolved by running following yum transaction:

[code]
$ yum shell
> remove compat-mysql51
> install mysql-community-libs-compat
> run
[/code]

This will update affected mysql libraries to newer version without breaking any dependencies.