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

Reply via email to