patternMinor
You do not have privileges to manipulate with the users!
Viewed 0 times
theyoumanipulateprivilegeswithusersnothave
Problem
Error message:
Appears in PhpMyAdmin using Mariadb 10.3.7 on MacOs High Sierra installation from Homebrew
I'm logged in as root
installed and rebooted with multiple server options: Mysql 5.7, Mysql 8.0
Mariadb 10.2 and 10.3.7.
I've tried everything from granting tables, flushing the permissions.
I need to be able to edit users from the PhpMyAdmin page and its not allowing me even though I have root access (with password set)
You do not have privileges to manipulate with the users!Appears in PhpMyAdmin using Mariadb 10.3.7 on MacOs High Sierra installation from Homebrew
I'm logged in as root
installed and rebooted with multiple server options: Mysql 5.7, Mysql 8.0
Mariadb 10.2 and 10.3.7.
I've tried everything from granting tables, flushing the permissions.
I need to be able to edit users from the PhpMyAdmin page and its not allowing me even though I have root access (with password set)
Solution
According to comments in this Github issue report for phpMyAdmin, you probably need to set this option:
in
$cfg['Servers'][$i]['DisableIS'] = true;in
config.inc.php. Though it sounds like this is a workaround for a bug, so may be fixed in later releases or not an issue in earlier releases.Code Snippets
$cfg['Servers'][$i]['DisableIS'] = true;Context
StackExchange Database Administrators Q#210786, answer score: 3
Revisions (0)
No revisions yet.