Control Web Panel
WebPanel => How to => Topic started 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/
-
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
-
in /scripts folder on every server you have script which will upgrade MySQL and phpMyAdmin.
-
Even mysql upgrade article is available so one can do that too.
-
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
cd /usr/local/cwpsrv/var/services
Make a backup of the old phpMyAdmin into the root directory and pma folder
mv pma /root/
Download the latest phpMyAdmin
wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip
Unzip the downloaded archive
unzip phpMyAdmin-latest-all-languages.zip
Remove the downloaded archive, it's important to remove it now!
rm -rf phpMyAdmin-latest-all-languages.zip
Rename the "phpMyAdmin" folder to "pma"
mv phpMyAdmin-* pma
Delete the included stock config file, it's important!
rm -rf pma/config.sample.inc.php
Copy the old CWP config file from the backup to the new phpMyAdmin
cp /root/pma/config.inc.php /usr/local/cwpsrv/var/services/pma/
Fix permissions on the files and folders
chown -R cwpsvc:cwpsvc pma
Tested and works fine.
-
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
-
^^^^ BUMP PLEASE ^^^^
-
Things I don't want tidied up/reverted behind my back simply get a
chattr +i <file>
or
chattr +i <directory>
So in this case:
chattr +i /usr/local/cwpsrv/var/services/pma/
-
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)
-
Is the MySQL root password the same as your system root password?
-
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
-
So the latest version of phpmyadmin not compatible with cwp ?
-
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.
-
i will try it and i will give you the answer
THANKS
-
(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. :'( :'( :'(
-
And you can't login with your mysql root password? It should be the same credentials as are stored here:
/root/.my.cnf
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
-
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
-
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
-
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 !
-
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.
-
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 ?
-
If root pw = mysql root pw it auto-logins just fine under CWP Admin. Or save credentials with your web browser...
-
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 ?
-
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.
-
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.
-
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/
-
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.
-
Hi there!
I have CWP + Almalinux 8.10 and I just wanna help others who will come this days for:
- Upgrade PHPMyAdmin in CWP: https://web.archive.org/web/20230129015402/https://www.uxlinux.com/how-to-update-phpmyadmin-latest-version-on-cwp-centos-webpanel/
- Upgrade MariaDB 10.X to 10.11: https://www.alphagnu.com/topic/548-upgrade-mariadb-105-to-11/
- Autologin problems? That help me: "Sandeep says: you need to login with password then phpmyadmin autologin will work."
From our forum: http://forum.centos-webpanel.com/centos-webpanel-bugs/error-when-accessing-phpmyadmin-from-the-user-side/msg34930/#msg34930