Under CWP you can easily upgrade phpMyadmin to latest version without too many configuration, phpMyAdmin is a PHP script which gives users the ability to interact with their MySQL server along with easy to use GUI to manage your databases.
In this tutorial update process is covered step by step in 2 parts first update/installation and second configuration which will be found at STEP 2.
You can also run this command to update phpmyadmin :
For manual update follow this steps :
Lets get started with update procedure :
Step 1 Updating/Installing
Backup the current installation :
mv /usr/local/cwpsrv/var/services/pma /usr/local/cwpsrv/var/services/pma.baks
Downloading phpMyadmin from official source :
cd /usr/local/cwpsrv/var/services/ wget https://files.phpmyadmin.net/phpMyAdmin/4.9.2/phpMyAdmin-4.9.2-all-languages.zip
Installing phpMyadmin :
cd /usr/local/cwpsrv/var/services/ unzip phpMyAdmin-4.9.2-all-languages.zip mv phpMyAdmin-4.9.2-all-languages pma
Done you’ve updated the phpmyadmin
Step 2 Configuration
How to Setup and Configure blowfish_secret in phpMyadmin on CWP
Navigate to /usr/local/cwpsrv/var/services/pma
Rename phpmyadmin sample config file to main config file :
mv config.sample.inc.php config.inc.php
Then edit config.inc.php file to setup blow_fish with your favorite editor through SFTP or you can do it via command :
cd /usr/local/cwpsrv/var/services/pma nano config.inc.php
Now find this phrases :
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
Now we’ll generate blowfish password hash :
Go to this site and generate a hash by entering secure password (random words) : http://www.passwordtool.hu/blowfish-password-hash-generator
Once you generated the hash copy and add this to phpmyadmin config file :
Add the hash to config :
$cfg['blowfish_secret'] = '$2a$07$soz2eS3qMvw1PdzMlUwYpOK8AuzH3I3gyoN7ncnSkblZ7iEfcx3Qm'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
save the file and exit.
Done you’ve configured phpmyadmin and blow_fish secret successfully. login to phpmyadmin for the check.
After successful installation remove the old backup folder :
rm -rf /usr/local/cwpsrv/var/services/pma.baks