phpmyadmin shows only one database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
noguru
Forum Commoner
Posts: 61
Joined: Thu Jun 06, 2002 4:03 am
Location: Just north of the City Of Gold, Land of Milk and Honey

phpmyadmin shows only one database

Post 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.
bozo
Forum Newbie
Posts: 2
Joined: Fri Dec 06, 2002 4:24 am

Post 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!
Post Reply