[solved] Update phpmyadmin and mysql debian 10

Hi,

Is someone kown how to update phpmyadmin following the installation of the perfect server ?
After apt-get update && upgrade, i had some problems with apache (solved) but phpmyadmin is not up to date.

thanks for your feedback.

 

phpmyadmin is to be installed manually following that tutorial, so I guess you will have to uninstall the one that come with debian 10 and install the latest version of it manually.

 

You have several options with phpmyadmin:
1) Do all manually
2) use the docker image (https://docs.phpmyadmin.net/en/latest/setup.html#installing-using-docker)
3) Use debian package and upgrade manually (will be overwritten if there comes a new debian package). Just delete the folder /usr/share/phpmyadmin and install new files there (adjust config and add blowfish key)
4) Use www.adminer.org (same functionality, just 1 php file -> easier config/setup)

 

Thanks for your anwsers, for you what is the best and secure way to do it ?

 

I would only suggest you to follow the tutorial hence removing default debian phpmyadmin is necessary to be done before that.

 

ok thank for your advice.

 

this will update phpMyAdmin to the current latest stable release 4.9.2

Code:

sudo mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bak
sudo mkdir /usr/share/phpmyadmin/
cd /usr/share/phpmyadmin/
sudo wget https://files.phpmyadmin.net/phpMyAdmin/4.9.2/phpMyAdmin-4.9.2-all-languages.tar.gz
sudo tar xzf phpMyAdmin-4.9.2-all-languages.tar.gz
sudo mv phpMyAdmin-4.9.2-all-languages/* /usr/share/phpmyadmin
sudo nano /usr/share/phpmyadmin/libraries/vendor_config.php

search for the lines containing TEMP_DIR and CONFIG_DIR and change them to:

Code:

define('TEMP_DIR', '/var/lib/phpmyadmin/tmp/');
define('CONFIG_DIR', '/etc/phpmyadmin/');

***** some settings have changed now for versions 5.0.1 and above.... and blowfish_secret needs to be configured as well.. use the settings below for v5.*:

edit /usr/share/phpmyadmin/libraries/vendor_config.php
Code:
'tempDir' => '/tmp/'
'configFile' => '/etc/phpmyadmin/config.inc.php',


also, i already had in /etc/phpmyadmin/config.inc.php:
Code:
// Load secret generated on postinst
if (check_file_access('/var/lib/phpmyadmin/blowfish_secret.inc.php')) {
require('/var/lib/phpmyadmin/blowfish_secret.inc.php');
}

and /var/lib/phpmyadmin/blowfish_secret_inc.php already contained:
Code:
<?php
$cfg['blowfish_secret'] = '<redacted>';

the blowfish config may have been added during an earlier manual update to 5.0.1.. i know i never had to change anything for that to go up to 5.2.0

***** end of edit for v5.* config..


save the file, then to clean up:

Code:

sudo rm /usr/share/phpmyadmin/phpMyAdmin-4.9.2-all-languages.tar.gz
sudo rm -rf /usr/share/phpmyadmin/phpMyAdmin-4.9.2-all-languages

then once you've tested phpMyAdmin and are sure everythings ok, you can remove the backup folder:

Code:

sudo rm -rf /usr/share/phpmyadmin.bak

 

great solution nhybgtvfr thanks a lot

 

just a notice for anyone looking to update phpMyAdmin using the instructions I posted above. 4.9.4 works without problems, if you want to stick to the 4.* releases.
5.0.1 also works without problems (at least on ubuntu 18.04. using php7.3 or php7.4)

Known issue: the reported current release version may display incorrectly on the main page (for instance, "Version information: 5.0.1, latest stable version: 4.9.4"). This is expected to be fixed in the next routine bug fix release.

 

I have update to 4.9.4
and now it works well.
thank you very much indeed

 

For your info so is phpMyAdmin now in backports. No need to manually download and install.
https://packages.debian.org/buster-backports/phpmyadmin
4.9.4 is not safe, you need atleast 4.9.5.

 

how do I install version 4.9.5?

[QUOTE = "elmacus, post: 405595, membro: 82380"] Per tua informazione, phpMyAdmin è ora in backport. Non è necessario scaricare e installare manualmente.
https://packages.debian.org/buster-backports/phpmyadmin
4.9.4 non è sicuro, è necessario almeno 4.9.5. [/ PREVENTIVO]

 

From Debian backports.
https://backports.debian.org/
https://wiki.debian.org/it/Backports

 

Thanks, but with your guidance I don't feel confident about doing a safe job