Re: create db in separate directory

2001-03-27 Thread Thomas Mayerhofer
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 dbfi

Re: create db in separate directory

2001-03-21 Thread Eric Fitzgerald
Databases are essentially just directories. What you do is create a directory in the users home directory. Then, do this: ln -s /path/to/home/dbdir /path/to/mysql/data/dir/somedbname Then grant the user access to that db. Your all set :) - Original Message - From: "Andre Guerrero" <[E