Page 1 of 1

How to update phpmyadmin?

Posted: Thu Jan 28, 2016 9:41 am
by pandabb
Hello guys, how to update phpmyadmin ?
I see a notification A newer version of phpMyAdmin is available and you should consider upgrading. The newest version is 4.5.4, released on 2016-01-28.

Changelog for the update:
https://www.phpmyadmin.net/files/4.5.4/

Thank You

P.S

I also updated my php from 5.4 to 5.6.17 , the long characters or id below , is it normal?

Code: Select all

Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.6.17
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $ 
PHP extension: mysqli Documentation
PHP version: 5.6.17

Re: How to update phpmyadmin?

Posted: Thu Jan 28, 2016 11:24 am
by skurudo
- download https://www.phpmyadmin.net/downloads/
- extract in temp folder
- make backup /usr/share/phpMyAdmin
- copy from your temp folder to /usr/share/phpMyAdmin
- check permissions

And you can add patch - viewtopic.php?f=14&t=10307

Re: How to update phpmyadmin?

Posted: Thu Jan 28, 2016 4:35 pm
by pandabb
Thank you.

What is the permision of the folder phpMyadmin, should it be root:root?

Second, ive succesfully updated phpmyAdmin but i encountered blowfish error again, i checked the config at /etc/phpmyadmin/config.inc.php blowfish key already exist.

Then i checked the folder /user/share/phpMyAdmin there's a file called sample.config.inc
I renamed that to config.inc.php and added blowfish key, then it works.

Did i do the right thing ? Because it's supposed to read the file to /etc/PhpMyadmin now its reading it from /user/share/phpMyAdmin now /etc/phpMyAdmin/config.inc.php is useless because its not being read.

Thanks!

Re: How to update phpmyadmin?

Posted: Fri Jan 29, 2016 7:03 am
by skurudo
pandabb wrote:What is the permision of the folder phpMyadmin, should it be root:root?
Yep.

Code: Select all

-rw-r--r--   1 root root 
pandabb wrote:Second, ive succesfully updated phpmyAdmin but i encountered blowfish error again, i checked the config at /etc/phpmyadmin/config.inc.php blowfish key already exist. Then i checked the folder /user/share/phpMyAdmin there's a file called sample.config.inc I renamed that to config.inc.php and added blowfish key, then it works. Did i do the right thing ?
4.5.x version have this blowfish stange behavior.
In older version I don't remember this.
You did right.
pandabb wrote:Because it's supposed to read the file to /etc/PhpMyadmin now its reading it from /user/share/phpMyAdmin now /etc/phpMyAdmin/config.inc.php is useless because its not being read.
Perhaps there is a difference between installing from the package and from the website. I think it's not so important. In ideal world in /etc/phpmyadmin should be simlynk to /usr/share/phpmyadmin, but there's no such thing. ;-)

Re: How to update phpmyadmin?

Posted: Fri Jan 29, 2016 7:14 am
by pandabb
Thanks for the confirmation, and yes i read that some package have different location for config. I also applied the patch and copied the pma password to the new config and its working well.

Re: How to update phpmyadmin?

Posted: Sun Feb 25, 2018 3:19 pm
by tkramer
Thanks @skurudo!
Still works!! I upgraded to version 4.7.8 on Debian9.3 and PHP7.2 without problems!!

Re: How to update phpmyadmin?

Posted: Wed Feb 28, 2018 8:25 am
by skurudo
It's nice to hear @tkramer ;-)

Re: How to update phpmyadmin?

Posted: Thu Jan 17, 2019 4:21 pm
by servraid
skurudo wrote:
Thu Jan 28, 2016 11:24 am
- download https://www.phpmyadmin.net/downloads/
- extract in temp folder
- make backup /usr/share/phpMyAdmin
- copy from your temp folder to /usr/share/phpMyAdmin
- check permissions

And you can add patch - viewtopic.php?f=14&t=10307
There is couple of issues with these instructions you gave :
1. the setup for vestcp using phpmyadmin is different the config.php file is located in etc/phpmyadmin https://vestacp.com/docs/#config-log-lo ... ian-ubuntu
so you need to copy this file to your usr/share/phpmyadmin folder
2. there is no TempDir location in the vesta config.php phpmyadmin

Vestacp setup phpmyadmin differently including even the way it's spelled. phpmyadmin not phpMyAdmin


updated instruction would be great thanks!