PHPMyAdmin 5.0.0


Verified User
May 31, 2008
The new major release of PHPMyAdmin was released few days ago. Few important things to know:

1. It does not support PHP versions 7.0 and earlier;

2. "PHP versions prior to 7.4 are unable to authenticate to a MySQL 8.0 or newer server (our tests show the problem actually began with MySQL 8.0.11). This relates to a PHP bug There is a workaround, that is to set your user account to use the current-style password hash method, mysql_native_password. This unfortunate lack of coordination has caused the incompatibility to affect all PHP applications, not just phpMyAdmin. For more details, you can see our bug tracker item at We suggest upgrading your PHP installation to take advantage of the authentication methods."

What new to expect in it:
  • Enable columns names by default for CSV exports
  • Add Metro theme
  • Automatically add the index when creating an auto increment column
  • Improvements to exporting views
  • Prompt the user for confirmation before running an UPDATE query with no WHERE clause
  • Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard)
  • Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u)
  • Use charset 'windows-1252' when export format is MS Excel


Verified User
Nov 20, 2019
I'd like to note phpmyadmin_ver=5 needs to be set for old installations to get phpMyAdmin 5 install/update :)
I get HTTP Error 500 after updating to version 5, any idea what went wrong possibly?


Verified User
Jan 16, 2018
I also had an error 500 after updating to version 5.

I looked in the http error.logs and found
/var/www/html/phpMyAdmin/.htaccess: Invalid command 'php_value', perhaps misspelled or defined by a module not included in the server configuration

I have a custom config (perfectly workin with version 4) on /usr/local/directadmin/custombuild/custom/phpmyadmin
.htaccess: php_value max_input_vars 2000 # to solve "Warning: a form on this page has more than xxx fields" when exporting a db.

After removing the .htaccess the problem was solved.

I did not need to set phpmyadmin_ver=5.
@smtalk: in wich config file should this be set?

@jayw1: maybe you find your solution in the logs.