[cobalt-developers] Simple question about MySQL

["Widebore Communications" <wbcoms@xxxxxxxxxxx>]

Hello, I wonder if someone could help me. I am running MySQl on a Raq4. I
have created a database, and from the telnet/mysql command line I have
successfully assigned that database to a particular user.

The problem is that when that user accesses it through phpMyAdmin, he is
able to see all the databases on the server, even though he is able to
access only his own database, and none of the others.

I tried to use "revoke grant show databases on *.* from user" (then planning
on specifically granting show on this database to the user) but it says
there is a syntax error. What am I doing wrong/is there a better way of
doing it?

Many thanks.

Mandar Marathe.