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.

[gpl.one]

@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

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 It would be interesting not to update the /services/ folder when it is not necessary, I have also tried to change phpMyAdmin, but CWP updates replace the folder again to the previous version.

[sandeep]

ohh i forgot to check this, will check it soon

[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 !:

ohh i forgot to check this, will check it soon

Hi "sandeep",

The phpMyAdmin latest version is 5.0.1

NOTE FROM PHPMYADMIN DEVELOPER:

This is a reminder that phpMyAdmin 4.9.3 is in the long-term support phase where it will only get important security fixes and critical bug fixes. Users are suggested to migrate to version 5.0.x

You have any news for this update ?

Thanks in advance for the support.

[Automata]

@sandeep

@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 !:

ohh i forgot to check this, will check it soon

Hi "sandeep",

You have any news for this update ?

Thanks in advance for the support.

[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 !:

ohh i forgot to check this, will check it soon

Hi "sandeep", you have any news ?

Thanks in advance for the support.

[sandeep]

actually issue is cwp update it reverting back the phpmyadmin version. I need to check it but didn't getting free time for it hopefully i'll check it in 1-2 days