PHPMyAdmin 5.0.0

wattie

Verified User
Joined
May 31, 2008
Messages
1,041
Location
Bulgaria
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 https://bugs.php.net/bug.php?id=76243. 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 https://github.com/phpmyadmin/phpmyadmin/issues/14220. 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
 

jayw1

Verified User
Joined
Nov 20, 2019
Messages
127
Location
USA
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?
 

MSN

Verified User
Joined
Jan 16, 2018
Messages
6
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.
 
Top