hy,

ive alway the problem with several users on a web-server:

each user should have the possibility to create a database -
this is ok - the databases are in ./mysql/var . If a user creates
a database all files are owned by the user root - and so the
owner of the db has no rights to copy the dbfiles
to an other location ...(only root) ??!!

user xyz create a db test:

[xyz]# mysqladmin -u xyz -p create test

and than :

ls -ld ./mysql/var:

drwx------- 2 root   root            1024 Mar 27 10:46 test

Is it possible to configure mysql so that each database is stored
in the users home/dir  or the db is user xyz ??

thanks for help !!!

thomas



---------------------------------------------------------------------
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