How to update phpMyAdmin v4.7.9 outdated version to the latest phpMyAdmin v4.9.2 for CWP and CWP PRO for Centos 7 !

Automata

Hi,

how to update phpMyAdmin v4.7.9 outdated version to the latest version of phpMyAdmin 4.9. which was released on 22 November, 2019 for CWP (Centos Web Panel) and CWP PRO (Centos Web Panel Pro) for Centos 7 !

This is the official link for this latest and stable release of phpMyAdmin:

https://www.phpmyadmin.net/files/4.9.2/

Thanks in advance for the support.

NOTE:

I am aware that at the moment with CWP (Centos Web Panel) and CWP PRO (Centos Web Panel Pro) for Centos 7 the autologin function only works with the phpMyAdmin v4.7.9 outdated version released on 05 March, 2018.

sandeep

hello
updated the post here
https://www.mysterydata.com/how-to-update-phpmyadmin-latest-version-on-cwp-centos-webpanel/

Automata

Hi "sandeep",

I have used your guide and i have two problem:

Problem 1:

After upgrading phpMyAdmin to v4.9.2 the 2FA (Two Factor Authentication) is active but i have never activated it and now i can't log in as i can solve this problem ?

Problem 2:

The $ cfg ['TempDir'] (./tmp/) folder is not accessible. phpMyAdmin is unable to pre-store templates and will slow down due to this.

Thanks in advance for the support.

sandeep

@Automata said in How to update phpMyAdmin v4.7.9 outdated version to the latest phpMyAdmin v4.9.2 for CWP and CWP PRO for Centos 7 !:

Problem 2:
The $ cfg ['TempDir'] (./tmp/) folder is not accessible. phpMyAdmin is unable to pre-store templates and will slow down due to this.
Thanks in advance for the support.

this doesn't needed in CWP you can ignore it.

for problem 1 :
Can you provide some screenshot ?

Automata

Hi,

for Problem 1 i have resolved with this commands:

mysql -u root -p "YourPassword"

DELETE FROM phpmyadmin.pma__userconfig WHERE username='root';

Thanks in advance for the support.

Automata

Hi,

for Problem 2 i have resolved with this commands:

Opened CWP File Manager and go to /usr/local/cwpsrv/var/services/pma/

Edit config.inc.php file and add this command:

$cfg['TempDir'] = '/tmp';

Thanks in advance for the support.

Automata

Hi,

Problem 3:

On phpMyAdmin v4.9.2 i have:

Server connection: SSL inactive

Please help me to solve this problem.

Thanks in advance for the support.

sandeep

try login with hostname:2031/pma and check

Automata

Hi,

i have logged with hostname:2031/pma but the problem remain: "Server connection: SSL inactive"

Please help me to solve this problem.

Thanks in advance for the support.

sandeep

can you provide the hostname ?

Automata

@sandeep said in How to update phpMyAdmin v4.7.9 outdated version to the latest phpMyAdmin v4.9.2 for CWP and CWP PRO for Centos 7 !:

can you provide the hostname ?

Yes, with private message chat function on your forum profile if it is ok for you ?

Automata

Hi,

Problem 4:

I made the update from phpMyAdmin v4.7.9 to phpMyAdmin v4.9.2 but at the moment CWP PRO (Centos Web Panel Pro) for Centos 7 has reported it automatically and by itself to the phpMyAdmin v4.7.9 !

Please help me to solve this problem.

Thanks in advance for the support.

sandeep

@Automata said in How to update phpMyAdmin v4.7.9 outdated version to the latest phpMyAdmin v4.9.2 for CWP and CWP PRO for Centos 7 !:

@sandeep said in How to update phpMyAdmin v4.7.9 outdated version to the latest phpMyAdmin v4.9.2 for CWP and CWP PRO for Centos 7 !:

can you provide the hostname ?

Yes, with private message chat function on your forum profile if it is ok for you ?

okay

Automata

@sandeep

Hi,

Problem 4:

I made the update from phpMyAdmin v4.7.9 to phpMyAdmin v4.9.2 but at the moment CWP PRO (Centos Web Panel Pro) for Centos 7 has reported it automatically and by itself to the phpMyAdmin v4.7.9 !

Please help me to solve this problem.

Thanks in advance for the support.