The repositories of CentOS no longer include MySQL, which is widely considered to be the most popular and dependable open-source relational database management system now available. Since the release of CentOS 6, the default repositories of CentOS have begun supporting MariaDB as the default relational database system. MariaDB is an excellent alternative to MySQL since it functions in a manner that is backwardupdating compatible with MySQL.
Note Before update You Must Take a Backup of your Full Databaes.
mysql -V
yum update
rpm -Uvh https://repo.mysql.com/mysql80-community-release-el6-3.noarch.rpm
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
yum update mysql-server
mysql -V
service mysqld status
service mysqld restart
service mysqld stop