Control Web Panel

WebPanel => How to => Topic started by: brijendrasial on March 22, 2015, 06:30:13 PM

Title: Upgrade PhpMyAdmin
Post by: brijendrasial on March 22, 2015, 06:30:13 PM
The tutorial below will help you to upgrade PhpMyAdmin
https://blog.bullten.com/upgrading-phpmyadmin-in-centos-web-panel-cwp/
Title: Re: Upgrade PhpMyAdmin
Post by: handsomechap on March 31, 2015, 03:03:13 PM
You may want to mention that this requires mysql 5.5+ otherwise you will break phpmyadmin if you try this on the default mysql which ships with CWP
Title: Re: Upgrade PhpMyAdmin
Post by: Administrator on March 31, 2015, 05:05:05 PM
in /scripts folder on every server you have script which will upgrade MySQL and phpMyAdmin.
Title: Re: Upgrade PhpMyAdmin
Post by: brijendrasial on April 01, 2015, 03:03:59 AM
Even mysql upgrade article is available so one can do that too.
Title: Re: Upgrade PhpMyAdmin
Post by: Aalesund on August 29, 2022, 09:04:44 AM
Quote from: Administrator on March 31, 2015, 05:05:05 PM
in /scripts folder on every server you have script which will upgrade MySQL and phpMyAdmin.
At this moment "upgrade_mysql" script is too old and outdated because it checks for MYSQL 5.5 instead of MariaDB and phpMyAdmin 4.x

=======================================================
So, here is a manual command for upgrade to the latest phpMyAdmin:

Go to directory
Code: [Select]
cd /usr/local/cwpsrv/var/services
Make a backup of the old phpMyAdmin into the root directory and pma folder
Code: [Select]
mv pma /root/
Download the latest phpMyAdmin
Code: [Select]
wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip
Unzip the downloaded archive
Code: [Select]
unzip phpMyAdmin-latest-all-languages.zip
Remove the downloaded archive, it's important to remove it now!
Code: [Select]
rm -rf phpMyAdmin-latest-all-languages.zip
Rename the "phpMyAdmin" folder to "pma"
Code: [Select]
mv phpMyAdmin-* pma
Delete the included stock config file, it's important!
Code: [Select]
rm -rf pma/config.sample.inc.php
Copy the old CWP config file from the backup to the new phpMyAdmin
Code: [Select]
cp /root/pma/config.inc.php /usr/local/cwpsrv/var/services/pma/
Fix permissions on the files and folders
Code: [Select]
chown -R cwpsvc:cwpsvc pma
Tested and works fine.
Title: Re: Upgrade PhpMyAdmin
Post by: Jack_C on December 11, 2022, 06:49:16 PM
Thanks,
I have managed to upgrade to the new version of phpmyadmin
but after 24 hours the script reverts back to the old one again.

What am I doing wrong?
Thanks for the reply
Title: Re: Upgrade PhpMyAdmin
Post by: Jack_C on January 22, 2023, 07:18:37 PM
^^^^  BUMP PLEASE  ^^^^
Title: Re: Upgrade PhpMyAdmin
Post by: overseer on January 22, 2023, 08:37:51 PM
Things I don't want tidied up/reverted behind my back simply get a
Code: [Select]
chattr +i <file>or
Code: [Select]
chattr +i <directory>So in this case:
Code: [Select]
chattr +i /usr/local/cwpsrv/var/services/pma/
Title: Re: Upgrade PhpMyAdmin
Post by: brahmi on March 22, 2023, 08:32:07 AM
Good morning
after I followed the phpmyadmin migration steps without any problem, except that when I access phpmyadmin it asks me to enter the credentials, the interface does not automatically display as before.
Is there a solution or is there a missing step?
THANKS
(https://quickdotnetinfo.com/wp-content/uploads/2023/03/phpmyadmin.jpg)
Title: Re: Upgrade PhpMyAdmin
Post by: overseer on March 25, 2023, 03:57:09 PM
Is the MySQL root password the same as your system root password?
Title: Re: Upgrade PhpMyAdmin
Post by: brahmi on March 27, 2023, 08:55:10 AM
thank you for your reply
I did not change my password, I followed exactly the steps quoted by "Aalesund" even if I introduced user root and the password does not work
Title: Re: Upgrade PhpMyAdmin
Post by: brahmi on April 09, 2023, 08:58:17 AM
So the latest version of phpmyadmin not compatible with cwp ?
Title: Re: Upgrade PhpMyAdmin
Post by: overseer on April 09, 2023, 09:04:09 AM
No, that's not true at all. I deployed the latest phpMyAdmin 5.2.1 yesterday on all my servers. Follow Sandeep's directions here, replacing any instance of "4.9.2" with "5.2.1":
https://www.uxlinux.com/how-to-update-phpmyadmin-latest-version-on-cwp-centos-webpanel/

Also, the link to the Blowfish hash generator is no longer working, so Google a different one.
Title: Re: Upgrade PhpMyAdmin
Post by: brahmi on April 09, 2023, 09:07:33 AM
i will try it and i will give you the answer
THANKS
Title: Re: Upgrade PhpMyAdmin
Post by: brahmi on April 09, 2023, 09:47:24 AM
(https://quickdotnetinfo.com/wp-content/uploads/2023/03/phpmyadmin.jpg)

I just followed the steps one by one I still have the same problem it asks me to introduce user and password.  :'( :'( :'(
Title: Re: Upgrade PhpMyAdmin
Post by: overseer on April 09, 2023, 03:02:08 PM
And you can't login with your mysql root password? It should be the same credentials as are stored here:
Code: [Select]
/root/.my.cnf
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
Title: Re: Upgrade PhpMyAdmin
Post by: brahmi on April 09, 2023, 10:33:40 PM
I managed to access the phpmyadmin interface using root and the quoted password /root/.my.cnf
but the automatic connection does not work neither on the root nor on the customer account, I must always introduce user and password located in /root/.my.cnf
Title: Re: Upgrade PhpMyAdmin
Post by: kaibacef on December 26, 2023, 09:35:51 PM
Quote from: brahmi on March 22, 2023, 08:32:07 AM
Good morning
after I followed the phpmyadmin migration steps without any problem, except that when I access phpmyadmin it asks me to enter the credentials, the interface does not automatically display as before.
Is there a solution or is there a missing step?
THANKS
(https://quickdotnetinfo.com/wp-content/uploads/2023/03/phpmyadmin.jpg)

same problem here unable to login with the update
Title: Re: Upgrade PhpMyAdmin
Post by: webprobox on February 13, 2024, 11:35:12 AM
I know this is old post, but maybe it will help someone who has the same issue.

After successful install of Maria DB 11.3.1

I installed phpMyAdmin 5.2.1

and faced the same login issue.

Solution:

Simply login to your main CWP and update root password.

Works like a charm !

Title: Re: Upgrade PhpMyAdmin
Post by: mah1973 on April 16, 2024, 09:25:30 PM
Quote from: webprobox on February 13, 2024, 11:35:12 AM
I know this is old post, but maybe it will help someone who has the same issue.

After successful install of Maria DB 11.3.1

I installed phpMyAdmin 5.2.1

and faced the same login issue.

Solution:

Simply login to your main CWP and update root password.

Works like a charm !

Tried this and it's not working for me. No autologin after upgrading to latest version of phpMyadmin.
Title: Re: Upgrade PhpMyAdmin
Post by: mah1973 on April 16, 2024, 09:27:44 PM
Quote from: overseer on April 09, 2023, 09:04:09 AM
No, that's not true at all. I deployed the latest phpMyAdmin 5.2.1 yesterday on all my servers. Follow Sandeep's directions here, replacing any instance of "4.9.2" with "5.2.1":
https://www.uxlinux.com/how-to-update-phpmyadmin-latest-version-on-cwp-centos-webpanel/

Also, the link to the Blowfish hash generator is no longer working, so Google a different one.

The autologin feature is still working for you ?
Title: Re: Upgrade PhpMyAdmin
Post by: overseer on April 17, 2024, 12:55:00 AM
If root pw = mysql root pw it auto-logins just fine under CWP Admin. Or save credentials with your web browser...
Title: Re: Upgrade PhpMyAdmin
Post by: mah1973 on April 17, 2024, 10:34:34 AM
Quote from: overseer on April 17, 2024, 12:55:00 AM
If root pw = mysql root pw it auto-logins just fine under CWP Admin. Or save credentials with your web browser...

No , I mean for regular users not admin. Is it still working ?
Title: Re: Upgrade PhpMyAdmin
Post by: overseer on April 17, 2024, 01:40:33 PM
I can't test the default configuration, because I run CWP on an alternate port. Userland phpMyAdmin forwards to port 2087 which I don't support and block via CSF.
Title: Re: Upgrade PhpMyAdmin
Post by: mah1973 on April 19, 2024, 08:54:32 PM
Quote from: overseer on April 17, 2024, 01:40:33 PM
I can't test the default configuration, because I run CWP on an alternate port. Userland phpMyAdmin forwards to port 2087 which I don't support and block via CSF.
Ah , I see. thanks for the info.
Title: Re: Upgrade PhpMyAdmin
Post by: victoryel on October 11, 2024, 02:08:08 PM
If someone is searching a solution (as webarchive is down for now) you can find how to update phpmyadmin, here: https://blog.alphagnu.com/how-to-update-phpmyadmin-latest-version-on-cwp-centos-webpanel/
Title: Re: Upgrade PhpMyAdmin
Post by: Starburst on October 11, 2024, 02:41:07 PM
I've asked about this in the past, and CWP uses a customer phpMyAdmin, so unfortunately there is no way to update/upgrade it.

If you try & bypass this, you will break CWP, and hence your installation.
Title: Re: Upgrade PhpMyAdmin
Post by: cbstudiomx on November 28, 2024, 07:53:50 AM
Hi there!
I have CWP + Almalinux 8.10 and I just wanna help others who will come this days for: