[FIXED] MYSQL phpmyadmin Error updating / adding User Accounts

Issue

First apologies in advance if this is not appropriate, this is the first question from a long time fan!

I'm using phpMyAdmin When I try and update an existing user account, or create a new one I get this error message

When click through to edit the SQL this is the statement it is trying to run:

SHOW PLUGINS SONAME LIKE '%_password_check%'

I'm running MariaDB 5.5.52-0069 on a synology box. All stock. I used to be able to update user accounts etc, so I think I started getting the error messages when Synology updated PHP 5.6.28-0036 and phpMyAdmin (within a few minutes of each other) on 6-Dec-16. Details of the server follow:

I'm sure I'm missing a bunch of relevant information, but I don't know enough to know what I could be missing.

1:

Solution

Seems like it's phpMyAdmin's issue.

Work directly with mysql:

Find Your user in list:

SELECT * FROM mysql.user WHERE User = 'username';

Then if exist:

DELETE FROM mysql.user WHERE User = 'username';

Then create user:

GRANT ALL ON database_name_here.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'new_password';
GRANT ALL ON database_name_here.* TO 'username'@'localhost' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;

Answered By - num8er