While upgrading MySQL server on centos 6 from 5.5 to 5.7 you may encounter following error:
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
It can be resolved by running following yum transaction:
$ yum shell > remove compat-mysql51 > install mysql-community-libs-compat > run
This will update affected mysql libraries to newer version without breaking any dependencies.