Package: phpmyadmin

Version: 4.2.12-2+deb/u1

Debian : 2.5

Bug: phpmyadmin (users tabs) does not display any user, just the message:

Your privilege table structure seems to be older than this MySQL version!
Please run the mysql_upgrade command(mysql_fix_privilege_tables on older 
systems) that should be included in your MySQL server distribution to solve 
this problem!

Bug2: clicking on "new database"

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
#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


These bugs should be fixed but debian packages are not up to date


apt-cache policy phpmyadmin
phpmyadmin:
  Installed: 4:4.2.12-2+deb8u1
  Candidate: 4:4.2.12-2+deb8u2
  Version table:
     4:4.2.12-2+deb8u2 0
        500 http://ftp.fr.debian.org/debian/ jessie/main amd64 Packages
        500 http://security.debian.org/ jessie/updates/main amd64 Packages
        500 http://http.us.debian.org/debian/ stable/main amd64 Packages
*** 4:4.2.12-2+deb8u1 0
        100 /var/lib/dpkg/status

So I upgraded phpmyadmin ..... but stil the same bug appears

sudo apt-get --only-upgrade install phpmyadmin
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following packages will be upgraded:
  phpmyadmin
1 upgraded, 0 newly installed, 0 to remove and 65 not upgraded.
Need to get 3,853 kB of archives.
After this operation, 10.2 kB of additional disk space will be used.
Get:1 http://ftp.fr.debian.org/debian/ jessie/main phpmyadmin all 
4:4.2.12-2+deb8u2 [3,853 kB]
Fetched 3,853 kB in 0s (23.9 MB/s)
Reading changelogs... Done
Preconfiguring packages ...
(Reading database ... 64214 files and directories currently installed.)
Preparing to unpack .../phpmyadmin_4%3a4.2.12-2+deb8u2_all.deb ...
Unpacking phpmyadmin (4:4.2.12-2+deb8u2) over (4:4.2.12-2+deb8u1) ...
Processing triggers for man-db (2.7.0.2-5) ...
Processing triggers for hicolor-icon-theme (0.13-1) ...
Setting up phpmyadmin (4:4.2.12-2+deb8u2) ...
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf
dbconfig-common: flushing administrative password
apache2_invoke phpmyadmin: already enabled

I tried upgrading mysql 5.7

sudo mysql_upgrade -p
Enter password:
Checking if update is needed.
This installation of MySQL is already upgraded to 5.7.12, use --force if you 
still need to run mysql_upgrade

Reply via email to