procedimiento
Ejecute yum remove mysql -y
mv /var/lib/mysql /var/lib/mysql.old
vim /var/cpanel/cpanel.config cambiar mysql-version=8.0 a mysql-version=10.3
ver en WHM > MySQL/MariaDB Upgrade > 10.3 > Unattended
actualizar via linea de comandos : whmapi1 start_background_mysql_upgrade version=10.3
resetear whmapi1 set_local_mysql_root_password password=superSecurePassword
Bash:
mysql -ANe "SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('mysql','information_schema','performance_schema', 'sys')" > databases.txt
DBLIST=""
for DB in `cat databases.txt` ; do DBLIST="${DBLIST} ${DB}" ; done
MYSQLDUMP_OPTIONS="--routines --triggers --single-transaction"
mysqldump ${MYSQLDUMP_OPTIONS} --databases ${DBLIST} > all-dbs.sql
mysql < all-dbs.sql
for user in $(ls /var/cpanel/users); do echo $user; /usr/local/cpanel/bin/restoregrants --db=mysql --cpuser=$user --all; done
