Search code examples
mysqlphpmyadminmariadbsynology

MYSQL phpmyadmin Error updating / adding User Accounts

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

enter image description here

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:

enter image description here

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;