How to update phpMyadmin to Latest Version 4.9.2 on CWP – Centos Web Panel

by Sandeep B.

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 :

sh /scripts/mysql_phpmyadmin_update

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/

Installing phpMyadmin :

cd /usr/local/cwpsrv/var/services/
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

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

Rename phpmyadmin sample config file to main config file :


Then edit 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

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) :

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

If this post helps you in any way please consider a donation

Donate with PayPal :


You may also like


anjarn July 26, 2018 - 1:38 pm

after updating i get:

The $cfg[‘TempDir’] (./tmp/) is not accessible. phpMyAdmin is not able to cache templates and will be slow because of this.

how to fix it??

Sandy July 27, 2018 - 8:55 am

you don’t need that config under cwp. All will be fine and working

selow July 10, 2019 - 9:32 am

try this, $cfg[‘TempDir’] (/tmp/)

iceman September 30, 2019 - 4:58 pm

Just go to:

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

chown -R cwpsvc:cwpsvc pma

And you will not see that anymore.

moh July 31, 2019 - 11:01 am

after this , no more auto login from CWP to phpmyadmin
how i fix that , ?

Jose August 1, 2019 - 5:39 pm

Here the same,… no more autologin,… now error 404,…

Sandy August 3, 2019 - 9:01 am

hi what version you’ve installed ?
I’ve tested it and there is no issue like 404

Jose August 5, 2019 - 10:01 am

I updated from 10.1.41-MariaDB to 10.4.7-MariaDB
CWP version:

All working fine except that autologin show error 404

When click from CWP phpMyAdmin (url:

redirecto to:

and show 404

iceman September 30, 2019 - 5:01 pm

Give the permissions to new pma, admins of this site are missing this:

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

chown -R cwpsvc:cwpsvc pma

Riad Ahmed June 23, 2020 - 11:16 am

i change my php version on cwp for default all user. but when i login phpmyadmin on from cwp admin panel then on phpmyadmin not detected my default php version on phpmyadmin. It’s showing old version, when i try to login from user account then phpmyadmin not opening on user account.

Sandeep B. June 25, 2020 - 5:54 pm

phpmyadmin doesn’t rely on php switchers or selectors php versions. For more info open a topic in our forum


Leave a Comment