Page 1 of 1

phpmyadmin shows only one database

Posted: Fri Dec 06, 2002 3:56 am
by noguru
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.

Posted: Fri Dec 06, 2002 4:24 am
by bozo
You need to flush privileges each time you change permissions. Just login as root user again and click on the SQL link on top. Type in the following and submit:

flush privileges;

This should do the trick!