How to Update MySql and phpMyAdmin in Centos Web Panel

How to Update MySql and phpMyAdmin in CentOS Web Panel

Initially start the updating process by checking your current Mysql and phpMyAdmin versions from centos web panel UI.

Mysql version

phpMyAdmin version

To starting, updating the MySQL and phpMyAdmin change the directory to /scripts/ in the terminal.

[root@cwp Desktop]# cd /scripts/
[root@cwp scripts]# ls -l
total 92
-rw-rw-r-- 1 root root 1514 Dec  1 07:31 add_alert
-rw-r--r-- 1 root root  297 Nov 17 00:13 check_postqueue
-rw------- 1 root root  757 Jun 28  2015 cwp_bruteforce_protection
-rw------- 1 root root 1143 Jun 28  2015 cwp_monitor
-rw-r--r-- 1 root root  171 Oct 28 11:09 disk_check
-rw------- 1 root root  178 Nov 14 03:34 freshclam
-rw------- 1 root root  669 Jun 28  2015 install_imagick
-rw------- 1 root root  290 Jun 28  2015 install_maldet
-rw------- 1 root root 1224 Apr 21  2016 install_net2ftp
-rw-r--r-- 1 root root  700 Jan 19  2016 install_supportKey
-rw------- 1 root root  293 Jun 28  2015 list_domains
-rw------- 1 root root  317 Jun 28  2015 list_subdomains
-rw------- 1 root root  390 Jun 28  2015 list_users
-rw-r--r-- 1 root root  113 Jul 25  2016 mysql_fix_myisam_tables
-rw------- 1 root root 1883 Jun 28  2015 mysql_pwd_reset
-rw-r--r-- 1 root root  542 Oct 25 03:00 mysql_set_max_connections
-rw-r--r-- 1 root root   65 Oct 25 02:44 mysql_show_max_connections
-rw-r--r-- 1 root root  136 Oct 12 02:15 net_show_connections
-rw------- 1 root root  119 Jun 28  2015 update_cwp
-rw-rw-r-- 1 root root  828 Jan 11 16:52 update_ioncube
-rw------- 1 root root 2092 Nov 19  2015 upgrade_mysql
-rw------- 1 root root 1264 Aug 23 04:24 user_backup
-rw------- 1 root root  661 Jun 28  2015 whoowns

To upgrade the MySQL version, type the following command to retrieve the configuration file.

[root@cwp scripts]# vim upgrade_mysql

After running the upgrade script, run the following command to upgrade the MySQL version and phpMyAdmin version.

[root@cwp scripts]# sh upgrade_mysql
CWP MySQL &  phpMyAdmin Upgrade Script
#######################################
Running MySQL Compressed Backup
&hellip 
&hellip 
Installed:
  mysql55w.x86_64 0:5.5.54-1.w6                         mysql55w-devel.x86_64 0:5.5.54-1.w6                         mysql55w-libs.x86_64 0:5.5.54-1.w6                         mysql55w-server.x86_64 0:5.5.54-1.w6                        
Dependency Installed:
  libmysqlclient16.x86_64 0:5.1.69-1.w6                                                                                                                                                                                                      
Complete!
MySQL Upgrade Done
########################################
/usr/bin/mysql Ver 14.14 Distrib 5.5.54, for Linux (x86_64) using readline 5.1
--2017-02-09 13:51:47--  http://dl1.centos-webpanel.com/files/mysql/phpMyAdmin-4.3.13.1-all-languages.zip
Resolving dl1.centos-webpanel.com... 37.187.72.216
..
..
  inflating: phpMyAdmin-4.3.13.1-all-languages/view_create.php 
  inflating: phpMyAdmin-4.3.13.1-all-languages/view_operations.php 
  inflating: phpMyAdmin-4.3.13.1-all-languages/webapp.php 
phpMyAdmin upgraded

The MySQL and phpMyAdmin versions has been updated. Now check the updated mysql version.

Next check the updated phpMyAdmin version.

To login into phpMyAdmin,enter the mysql root user credentials.

Open the /root/.my.cnf file, you will enter the root user password.

[root@cwp ~]# vim .my.cnf

Now login and check the phpMyAdmin version.

phpMyAdmin login page

Updated phpMyAdmin version