Article directory
How CWP UpgradesphpMyAdminDatabase management to version 4.4?
just installedCWP Control Panel, if no changes are made, the default version is to install PHP5.4.
phpMyAdmin is a free one written in PHPsoftwaretools designed to be processed over the webMySQLmanagement.
phpMyAdminMySQLand MariaDB's detailed operations provide extensive support.
Common operations (managing databases, tables, columns, relations, indexes, users, permissions, etc.) can be performed through the user interface, but you still need the ability to execute arbitrary SQL statements directly.
Upgrade conditions for phpMyAdmin 4.4.15.10:
phpMyAdmin version 4.4.15.10 is compatible with PHP 5.3.7 to 7.0 and MySQL 5.5
phpMyAdmin 4.4.15.10
Released on 2017-01-23, see the release notes for details.
Since CWP defaults toMYSQL databaseIt is not version 5.5, so the MYSQL database must be upgraded to version 5.5.
For specific upgrade instructions, please refer to this article▼
1) Please make a backup of phpMyAdmin
mkdir /home/phpmyadmin_backup cp -rv /usr/local/apache/htdocs/phpMyAdmin/* /home/phpmyadmin_backup
2) Download and unzip phpMyAdmin
wget https://files.phpmyadmin.net/phpMyAdmin/4.4.15.10/phpMyAdmin-4.4.15.10-all-languages.tar.gz
tar zxvf phpMyAdmin-4.4.15.10-all-languages.tar.gz
cd phpMyAdmin-4.4.15.10-all-languages
3) Move all the files to the old folder of phpMyAdmin
yes | cp -rv * /usr/local/apache/htdocs/phpMyAdmin/
4) Permission settings for phpMyAdmin files
cd /usr/local/apache/htdocs/phpMyAdmin/
chown -R nobody:nobody *
5) Repair database tables & upgrade system tables
mysql_upgrade executes the following commands to check and repair tables and upgrade system tables:
mysqlcheck --all-databases --check-upgrade --auto-repair
6) Restart Apache
service httpd restart
7) View version
Log in now (http://your-ip/phpMyAdmin/).
If you see "phpMyAdmin version information: 4.4.15.10 (updated)" in the lower right corner, it means you have successfully upgraded PhpMyAdmin.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "How does CWP upgrade phpMyAdmin database management to version 4.4? , to help you.
Welcome to share the link of this article:https://www.chenweiliang.com/cwl-162.html
To unlock more hidden tricks🔑, welcome to join our Telegram channel!
If you like it, please share and like it! Your sharing and likes are our continuous motivation!
