Package: phpmyadmin
Version: 4.2.12
Debian 2.5
(request for update or infos to do it manually)
1- Clicking on the user tabs gives:
"Your privilege table structure seems to be older than this MySQL version!"
2- Clicking on the "new database" option gives:
"SELECT
s.SCHEMA_NAME,
s.DEFAULT_COLLATION_NAME
FROM `information_schema`.SCHEMATA s
GROUP BY BINARY s.SCHEMA_NAME
ORDER BY BINARY `SCHEMA_NAME` ASC
MySQL said: Documentation
#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains
nonaggregated column 'information_schema.s.SCHEMA_NAME' which is not
functionally dependent on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by"
- Can someone update phpmyadmin to its last version ?
- Or give me hints to what files need to be put in wich folder, on
debian there are many places where phpmyadmin can be found
Do I update them all ?
sudo find / -name phpmyadmin
/etc/phpmyadmin
/usr/share/doc/phpmyadmin
/usr/share/phpmyadmin
/usr/share/doc-base/phpmyadmin
/usr/share/dbconfig-common/data/phpmyadmin
/usr/share/lintian/overrides/phpmyadmin
/var/lib/phpmyadmin
/var/lib/apache2/conf/enabled_by_maint/phpmyadmin
/var/lib/mysql/phpmyadmin
