mysqladmin variables
I believe it is safe_show_database or some-such.
Marco Kammerer wrote:
> 3.22.38
>
> Hello guys
>
> I figured out how I can set up different user that are able to work
> on their own dbs.
>
> here is my command to add a db and a user;
>
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO
> bernduser@LOCALHOST IDENTIFIED BY '1234'
>
> But a questions:
> when I have added the user with root, log out and log in with the
> user bernduser, I am able to see all databases (just the names)
> is there a way to cut this? Of cource he is only able to work in his
> own, but I only want him to see his own db bernddb.
>
> Thanks Marco
>
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
