Creating mysql db/user

[barry]

I looked around and couldn't find any easy way to do this.

When a user creates a database I would like DA to add the user as with the '%' host as well as 'localhost' so users can connect to mysql from there home PCs.

Is there a way to do that? Or is the grant command done from inside the DA code?

-Barry

[S2S-Robert]

If you want to do it via the control panel check out this (http://www.directadmin.com/forum/showthread.php?s=&threadid=477) topic.

If you want it added right after you created the user you should add a shell script that runs right after the user creation. Don't recall where it's located and couldn't easily find it, but it's a script that runs right before / after you created / deleted the user.

[ProWebUK]

Theres a guide in the checklist, check my sig for link :)

Chris

[DirectAdmin Support]

The grant command is in the DA code, can't be edited.

John

[barry]

Originally posted by S2S-Robert
If you want it added right after you created the user you should add a shell script that runs right after the user creation. Don't recall where it's located and couldn't easily find it, but it's a script that runs right before / after you created / deleted the user. [/B]

Where do I add this shell script? I didn't see any mention of in the New Server Checklist topic.

[ProWebUK]

Originally posted by barry
Where do I add this shell script? I didn't see any mention of in the New Server Checklist topic.

To run scripts upon domain creation or deletion you can use the system built into DA - information can be found here:

http://www.directadmin.com/features.php?id=183

The checklist contains a link (under add-ons and advice section) to creating additional users in phpmyadmin.

Chris