RE: [cobalt-developers] Simple question about MySQL

["Peter Lorent" <lorent@xxxxxxxxxxxxxxx>]

In config.inc.php (directory MyAdmin) look for $cfgServers[1]['only_db] and
set it to the database you want to show.
Regards,
Peter

-----Oorspronkelijk bericht-----
Van: cobalt-developers-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]Namens Widebore
Communications
Verzonden: woensdag 11 december 2002 8:08
Aan: cobalt-developers@xxxxxxxxxxxxxxx
Onderwerp: [cobalt-developers] Simple question about MySQL


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.

_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers