phpmyadmin shows only one database
Posted: Fri Dec 06, 2002 3:56 am
Hi
I'm having problems giving phpmyadmin permissions to users on different mysql tables. Only one table is displayed when I login as a specific user.
I'm using phpmyadmin 2.3.2 with http authentication. In the config.inc.php file I've specified "http" for the authentication type as well as the root user and password as the controluser and controlpassword.
I've added a user called "is" in the mysql.user table with host "localhost" and all privileges "N". I've added records in the mysql.db table for each database on which this user has access. The fields are all "Y" except "Grant_Priv" and "References_Priv" which are "N". There's also a wildcard record here with host "%", database "test\_%", user "", all privileges "Y", except "Grant_Priv" (this is probably supposed to show all databases starting with the prefix "test", but it shows only one database which is called "test"). There is also a "test2" database as well as a couple of other databases which aren't showing either). I can view all tables when I login as root user, but when I login as user "is" it only shows the one database called "test".
Any help will be appreciated.
I'm having problems giving phpmyadmin permissions to users on different mysql tables. Only one table is displayed when I login as a specific user.
I'm using phpmyadmin 2.3.2 with http authentication. In the config.inc.php file I've specified "http" for the authentication type as well as the root user and password as the controluser and controlpassword.
I've added a user called "is" in the mysql.user table with host "localhost" and all privileges "N". I've added records in the mysql.db table for each database on which this user has access. The fields are all "Y" except "Grant_Priv" and "References_Priv" which are "N". There's also a wildcard record here with host "%", database "test\_%", user "", all privileges "Y", except "Grant_Priv" (this is probably supposed to show all databases starting with the prefix "test", but it shows only one database which is called "test"). There is also a "test2" database as well as a couple of other databases which aren't showing either). I can view all tables when I login as root user, but when I login as user "is" it only shows the one database called "test".
Any help will be appreciated.