Just to take a side-thought, does dtc really need root access
to MySQL?

You can grant a user rights to create a database, and in fact
can limit the names of the databases they can create/manipulate
using something like:

GRANT ALL PRIVILEGES ON `dbprefix%`.* TO [EMAIL PROTECTED]
IDENTIFIED BY 'password';

I'm assuming (I've not looked) that DTC keeps all its user's
databases seperate by prefixing with the siteID or something.

So a master DTC user with priveliges on `dtc_%` and user
databases called `dtc_siteID_%`.

Just a thought...

-- 
Paul "TBBle" Hampson, [EMAIL PROTECTED]

Shorter .sig for a more eco-friendly paperless office.

Attachment: pgpZ8iTlcpphr.pgp
Description: PGP signature

Reply via email to