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
