# phpMyAdmin wants me to upgrade

**URL:** <https://forums.percona.com/t/phpmyadmin-wants-me-to-upgrade/6449>\
**Category:** Other MySQL® Questions\
**Created:** [July 7, 2018, 11:05am UTC](https://forums.percona.com/t/phpmyadmin-wants-me-to-upgrade/6449 "2018-07-07T11:05:27Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![espenlg](https://avatars.discourse-cdn.com/v4/letter/e/4af34b/32.png) [@espenlg](https://forums.percona.com/u/espenlg)\
**Post date:** [July 7, 2018, 11:05am UTC](https://forums.percona.com/t/phpmyadmin-wants-me-to-upgrade/6449/1 "2018-07-07T11:05:27Z")

</div>

Hi everyone,

I’ve installed Percona Server for MySQL (5.7.22-22) on a fresh Ubuntu 16.04 LTS. I used followed the instructions and everything seems to be fine. The MySQL server is running and I’ve imported a database and it’s all good.

But then I wanted to install phpMyAdmin and I used apt-get install phpmyadmin and got version 4.5.4.1.

The thing is when I go to the User Accounts tab in phpMyAdmin I get 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!

This is not a production environment yet so I tried the mysql\_upgrade command but it didn’t change anything.

Anyone experienced the same and have a solution? Thank you!

---

<div class="post-metadata">

**Author:** ![espenlg](https://avatars.discourse-cdn.com/v4/letter/e/4af34b/32.png) [@espenlg](https://forums.percona.com/u/espenlg)\
**Post date:** [July 11, 2018, 5:16pm UTC](https://forums.percona.com/t/phpmyadmin-wants-me-to-upgrade/6449/2 "2018-07-11T17:16:26Z")

</div>

I found a way to fix this and will share it with you guys just in case I’m not the only one:  
[URL=“[Bug #1693778 “Viewing User accounts with phpMyAdmin and Percona ...” : Bugs : phpmyadmin package : Ubuntu](https://bugs.launchpad.net/ubuntu/+source/phpmyadmin/+bug/1693778)”][https://bugs.launchpad.net/ubuntu/+s...n/+bug/1693778[/URL]](https://bugs.launchpad.net/ubuntu/+s...n/+bug/1693778%5B/URL%5D)

So a small change in the file server\_privileges.lib.php solved the problem.

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [July 12, 2018, 4:42am UTC](https://forums.percona.com/t/phpmyadmin-wants-me-to-upgrade/6449/3 "2018-07-12T04:42:44Z")

</div>

Hello [espenlg](https://www.percona.com/forums/member/42147-espenlg), THANK YOU! It will likely help someone else in the future.

We took a look and it seems that the latest PhP MyAdmin source includes the fix, but it’s good for anyone who is stuck for now with an old version. Thanks again!

---

<div class="post-metadata">

**Author:** ![AntunesNeto](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@AntunesNeto](https://forums.percona.com/u/AntunesNeto)\
**Post date:** [November 21, 2018, 10:42am UTC](https://forums.percona.com/t/phpmyadmin-wants-me-to-upgrade/6449/4 "2018-11-21T10:42:32Z")

</div>

> [@espenlg;51843](#):
>
> I found a way to fix this and will share it with you guys just in case I’m not the only one:  
> [https://bugs.launchpad.net/ubuntu/+s…n/+bug/1693778](https://bugs.launchpad.net/ubuntu/+source/phpmyadmin/+bug/1693778)
> 
> So a small change in the file server\_privileges.lib.php solved the problem.

Mas como faço essa correção do Bug? Entrei nesse link aí mas não informa como corrige.

---

<div class="post-metadata">

**Author:** ![AntunesNeto](https://avatars.discourse-cdn.com/v4/letter/a/b3f665/32.png) [@AntunesNeto](https://forums.percona.com/u/AntunesNeto)\
**Post date:** [November 21, 2018, 10:43am UTC](https://forums.percona.com/t/phpmyadmin-wants-me-to-upgrade/6449/5 "2018-11-21T10:43:48Z")

</div>

Mas como faz para corrigir o bug? Entrei no link mas não informa como faz a correção.

Translate:  
But how do I fix this bug? I entered this link there but it does not report how it corrects.

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [November 21, 2018, 11:01am UTC](https://forums.percona.com/t/phpmyadmin-wants-me-to-upgrade/6449/6 "2018-11-21T11:01:34Z")

</div>

Hello [AntunesNeto](https://www.percona.com/forums/member/42481-antunesneto) if you aren’t in the latest version of phpMyAdmin it looks like the poster is saying you need to replace some code in the server\_privileges.lib.php file of phpMyAdmin … the actual code is at the ‘patch’ link, the second entry in that bug report.

Do, though, make sure that you a have a back up of the current file before you do anything in case you need to revert.
