MYSQL phpmyadmin Error updating / adding User Accounts

mysql phpmyadmin mariadb synology
Matt Lovett picture Matt Lovett · Dec 18, 2016 · Viewed 11.6k times · Source

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:

Answer

user2591294 picture user2591294 · Mar 1, 2017

Just create a folder lib under MySQL main folder and create sub-folder call plugin and it solved.

Related questions

phpMyAdmin allow remote users

I need to modify the file /etc/httpd/conf.d/phpMyAdmin.conf in order to allow remote users (not only localhost) to login # phpMyAdmin - Web based MySQL browser written in php # # Allows only localhost by default # # But allowing phpMyAdmin …

Read More
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I installed LAMP on Ubuntu 12.04 LTS (Precise Pangolin) and then set root password on phpMyAdmin. I forgot the password and now I am unable to login. When I try to change password through terminal I get: ERROR 2002 (HY000): Can't connect …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More