Dear Ulv,
> My problem is that every user sees every other users
> databases. Is there a way to setup mysql so that every local user has
his
> own empty database? Please tell me how this has to be set up.
When they can state "show databases", other users will see databases
where they have no access rights. They cannot see anything inside of
these databases, though, if the access rights are set correctly, like
this:
GRANT ALL ON user1_db TO "user1"@"localhost" IDENTIFIED BY "some_pw"
For user1, you would then create an empty database:
CREATE DATABASE user1_db
See http://www.mysql.com/doc/G/R/GRANT.html for details.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Ulv Michel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 11:53 AM
Subject: Setup own DB for each user?
> Hi all,
>
> I am running a webhosting server using SuSE 7.2 /mysql 3.23 /php 4. We
are
> hosting a small amount of virtual servers, allowing our customers to
user
> php and mysql. My problem is that every user sees every other users
> databases. Is there a way to setup mysql so that every local user has
his
> own empty database? Please tell me how this has to be set up.
>
> Thanks
>
> Ulv
>
>
> ---------------------------------------------------------------------
> 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
>
>
---------------------------------------------------------------------
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
