Sometimes you might have encountered dependency issue when upgrading MySQL version. In order to prevent the dependency issue, you can upgrade the MySQL db in single command like following.
Download the required Mysql version to be upgraded and go to the rpm file location, then execute the following command.
rpm Uvh mysql-community-{server,client,common,libs-compat,libs}-*.rpm
Download the required Mysql version to be upgraded and go to the rpm file location, then execute the following command.
rpm Uvh mysql-community-{server,client,common,libs-compat,libs}-*.rpm