Since a couple of revisions of phpMyAdmin ago, I'm
unable to browse the MySQL "users" table. When I go
to do this, it just hangs. This is true with 2.5.1.
I have MySQL-3.23.56 installed, and am able to browse
this table with other tools or through the command line.
I tried modifying the "control" user to be root, to
experiment, and the same problem occurs. Is this a
known bug, or did I do something wrong in the config?
I granted privileges to the "control" user and indeed
the "control" user is able to view other tables... and if I
remove the password for "control" phpmyadmin will show
an error from the mysql server.
If I use the command line mysql client to select from the
mysql.user database, I am able to read it fully without
any problem. So, I'm going to presume the bug is
somewhere in the phpmysqladmin process.
This is the mysql statement I used:
GRANT USAGE ON mysql.* TO 'control'@'localhost'
IDENTIFIED BY 'somepassword';
GRANT SELECT ON mysql.db TO 'control'@'localhost';
GRANT SELECT ON mysql.host TO 'control'@'localhost';
GRANT SELECT (Host, Db, User, Table_name, Table_priv,
ON mysql.tables_priv TO 'control'@'localhost';
GRANT SELECT (
Host, User, Select_priv, Insert_priv, Update_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv,
File_priv, Grant_priv, References_priv, Index_priv,
) ON mysql.user TO 'control'@'localhost';
I'm not sure how to debug this, and would appreciate
any assistance as it's very aggravating :-)