If you are having issues with phpMyAdmin 5, try phpMyAdmin-4.9.5 instead as this is the latest stable release for PHP 7.0 and lower and MySQL 5.4 and lower. If you are seeing an error “The secret passphrase in configuration (blowfish_secret) is too short.”, see below. Now log back in to phpMyAdmin and ensure the errors are gone. (Press CTRL + X, press Y and then press ENTER) PhpMyAdmin will now generate its own blowfish secret based on the install directory. Blowfish secretĬhange line to define('CONFIG_DIR', '/etc/phpmyadmin/') The blowfish secret is used by phpMyAdmin for cookie authentication. You may also see an error The configuration file now needs a secret passphrase (blowfish_secret). Open vendor_config.php sudo nano /usr/share/phpmyadmin/libraries/vendor_config.phpĬhange line to define('TEMP_DIR', '/var/lib/phpmyadmin/tmp/') phpMyAdmin is not able to cache templates and will be slow because of this. If you are seeing an error The $cfg (./tmp/) is not accessible. You can now log back into phpMyAdmin and check the current version. We want to move the contents of this folder to /usr/share/phpMyAdmin sudo mv phpMyAdmin-5.0.2-all-languages/* /usr/share/phpMyAdmin You should see a new folder phpMyAdmin-5.0.2-all-languages If you are having issues with phpMyAdmin 5.x, try phpMyAdmin-4.9.5 instead. If a later version is now available, make sure to change the commands below to match (and let me know in the comments so I can update the guide). In this guide we are using version 5.0.2, released March 2020. Visit the phpMyAdmin download page and look for the. Users are advised to migrate to version 5.įor PHP 7.1 and above, download phpMyAdmin 5.xįor PHP 5.5 to PHP 7.4, download phpMyAdmin-4.9.5 PhpMyAdmin version 4.x is now in the LTS phase, where only security fixes and critical bug fixes are made. To find out your PHP version in command line, run php -v. Update Feb 2020: phpMyAdmin 5 has been released but it is only compatible with PHP 7.1 and above. mv /usr/share/phpmyadmin/ /usr/share/phpmyadmin.bakĬreate a new phpMyAdmin folder sudo mkdir /usr/share/phpmyadmin/Ĭhange to directory cd /usr/share/phpmyadmin/ 2. You should back up your current phpMyAdmin folder by renaming it. In the meantime, if you have any suggestions on how to improve this guide, please let me know in the comments. I will try to update this guide for CentOS as soon as I get the chance to test it. For CentOS users, please refer to the comments section at the end of this page as commands will be different. It should also work for other Debian-based distributions without issue. This guide has been tested on Ubuntu 20.04, 18.04 and 16.04. In this article we will manually download and install the latest version of phpMyAdmin to resolve these issues. Since the release of Ubuntu 18.04 and other Linux distros, many people have been having compatibility issues with PHP 7.2 and phpMyAdmin 4.6 and above.

Phpmyadmin 4