(Dec 29) New version 0.9.8-18 has been released

Percona + MySql + php 7

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
BBuchanan1013
Posts: 139
Joined: Thu Jan 07, 2016 12:01 am

Percona + MySql + php 7

Postby BBuchanan1013 » Thu Jul 20, 2017 6:43 pm

So this is generally for phpmyadmin, Ubuntu 16, and Percona.

I found a bug where Phpmyadmin wouldn't allow you to view the users from the Percona server. It'd tell you to run

Code: Select all

root@server: mysql_upgrade

but this wouldn't fix the issue. So I went web searching. It's actually an issue between Percona and phpmyadmin.

The fix:
find: /usr/share/phpmyadmin/libraries/server_privileges.lib.php
Line: 4576

Code: Select all

 if (PMA_Util::getServerType() == 'MySQL'
         && PMA_MYSQL_INT_VERSION >= 50706
     ) {
         $password_column = 'authentication_string';


Needs an addition:

Code: Select all

if ((PMA_Util::getServerType() == 'MySQL' || PMA_Util::getServerType() == 'Percona Server')
         && PMA_MYSQL_INT_VERSION >= 50706
     ) {
         $password_column = 'authentication_string';


This worked for me, I wanted to share it in case anyone else ran into this issue.

Server version: 5.7.18-15
Apache/2.4.25
Version information: 4.5.4.1deb2ubuntu2 (phpmyadmin)

Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 2 guests