How to Upgrade phpMyAdmin to latest version ?

Hi am using old version of phpmyadmin and i want to upgrade it to latest version . so how can i do it.

am running debian 8 jessie

Supporter Asked on March 22, 2016 in Software.
Add Comment
1 Answer(s)
Best answer

first find phpyadmin installation directory on your system

 

# find / -name "phpmyadmin"
/var/lib/mysql/phpmyadmin
 /var/lib/phpmyadmin
 /etc/phpmyadmin
 /usr/share/lintian/overrides/phpmyadmin
 /usr/share/doc/phpmyadmin
 /usr/share/doc-base/phpmyadmin
 /usr/share/dbconfig-common/data/phpmyadmin
 /usr/share/phpmyadmin
 

/usr/share/phpmyadmin is correct phpMyAdmin installation directory, Just Delete/Remove everything from that directory

 # cd /usr/share/phpmyadmin/
 # rm -Rf *
 

Now download latest version of phpmyadmin and unzip it there

 # apt-get install zip # incase you do not have zip package so install it
 # cd /usr/share/phpmyadmin/
 # wget https://files.phpmyadmin.net/phpMyAdmin/4.6.6/phpMyAdmin-4.6.6-all-languages.zip
 # unzip phpMyAdmin-4.6.6-all-languages.zip
 # cd phpMyAdmin-4.6.6-all-languages
 # mv * /usr/share/phpmyadmin/
 # cd .. # go back one directory to clean downloaded files
 # rm phpMyAdmin-4.6.6-all-languages.zip # delete downloaded zip file
 

New version of phpmyadmin require mbstring so to install it

 

apt-get install libapache2-mod-php5           # for php 5
apt-get install libapache2-mod-php7.0         # for php 7

 

next find your php.ini and edit to add mbstring extension

nano /etc/php/5.6/apache2/php.ini

add mbstring and php_mysqli extension to php.ini

 

extension=mbstring
extension=php_mysqli

 

finally Restart Apache, MySQL or MariaDB service and check your phpmyadmin version

 service apache2 restart
 service mysql restart
 

or try with this

 /etc/init.d/apache2 restart
 /etc/init.d/mysql restart
 

if any issue of connecting to database then you need to configure phpmyadmin config file incase in first place you have installed phpmyadmin from source

 

cd /usr/share/phpmyadmin/ # switch to installation directory of phpmyadmin
apt-get install nano # incase you do not have editor
cp config.sample.inc.php config.inc.php
nano config.inc.php

* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg[‘blowfish_secret’] = ‘some long alpha numeric random string here ‘; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Look for the following lines and enter the MySQL server login details.

/* User used to manipulate with storage */
$cfg[‘Servers’][$i][‘controlhost’] = ”;
$cfg[‘Servers’][$i][‘controlport’] = ”;
$cfg[‘Servers’][$i][‘controluser’] = ‘root’;
$cfg[‘Servers’][$i][‘controlpass’] = ‘password’;

Restart Apache service and check phpmyadmin

service apache2 restart

 

to add google recaptcha to phpmyadmin check :: https://answers.w3db.xyz/question/how-to-add-google-recaptcha-to-phpmyadmin-login-screen/

Supporter Answered on March 22, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.