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
Reducing database licensing costs by over 90%
Cutting systems downtime by 60%
Lowering hardware expenditure by 70%
Reducing administration, engineering and support costs by up to 50%