Cannot add user in phpMyAdmin on MariaDB 5.5.x

Created:

2017-01-22 20:57:03 UTC

Modified:

2017-08-08 13:45:27 UTC

3

Was this article helpful?


Have more questions?

Submit a request

Cannot add user in phpMyAdmin on MariaDB 5.5.x

Applicable to:

  • Plesk Onyx for Linux

Symptoms

Cannot add user in phpMyAdmin on MariaDB 5.5.x:

Error
SQL query:
SHOW PLUGINS SONAME LIKE '%_password_check%'
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SONAME LIKE '%_password_check%'' at line 1

Cause

This is an issue #12757 of phpMyAdmin

Resolution

The issue is fixed in phpMyAdmin 4.6.6

If version of phpMyAdmin < 4.6.6, as a workaround modify the file /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/server_privileges.lib.php as follows, create backup first:

cp /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/server_privileges.lib.php /root/
vi /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/server_privileges.lib.php

before

function PMA_checkIfMariaDBPwdCheckPluginActive()
{
if (Util::getServerType() !== 'MariaDB') {
return false;
}

after

function PMA_checkIfMariaDBPwdCheckPluginActive()
{
if (!(Util::getServerType() == 'MariaDB' && PMA_MYSQL_INT_VERSION >= 100002)) {
return false;
}
Have more questions? Submit a request
Please sign in to leave a comment.