https://www.helpernt.com/vb/showthread.php?t=9310

https://www.helpernt.com/vb/showthread.php?t=9318

MySQL version: 10.1.40-MariaDB

mysqldump -u root -p --all-databases > all_databases.sql

MySQL root Password:

cat /root/.my.cnf

systemctl stop mariadb

yum remove mariadb mariadb-server -y

nano /etc/yum.repos.d/mariadb.repo

# MariaDB 10.3 CentOS repository list
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

yum install mariadb mariadb-server -y

systemctl start mariadb
systemctl enable mariadb

mysql_upgrade

yum -y update

systemctl restart mysql
systemctl restart httpd

mysql -v

 The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why. 
Or alternately go to 'Operations' tab of any database to set it up there.

Configuration of pmadb… not OKDocumentation
General relation features Disabled
 Create a database named 'phpmyadmin' and setup the phpMyAdmin configuration storage there.

cd /usr/local/cwpsrv/var/services

mv pma pma2018

wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip
unzip phpMyAdmin-latest-all-languages.zip

ls

mv phpMyAdmin-4.9.0.1-all-languages pma

/usr/local/cwpsrv/var/services

cd pma

mv config.sample.inc.php config.inc.php

/usr/local/cwpsrv/var/services/pma

nano /usr/local/cwpsrv/var/services/pma/config.inc.php

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

$cfg['TempDir'] = '/tmp';

systemctl restart mysql
systemctl restart httpd
systemctl restart sshd
systemctl restart lfd
systemctl restart named
systemctl restart nginx
systemctl restart varnish
systemctl restart dovecot
systemctl restart crond.service
sh /scripts/restart_cwpsrv
csf -r

cd /usr/local/cwpsrv/var/services/

rm -rf pma2018

usr/local/cwpsrv/var/services