Mysql add database

[VipGeek]

Via a backend script or command line, how do I add a database for a domain and a mysql user with proper access to that database?

Thanks

[sawbuck]

http://forums.cpanel.net/showthread.php?t=27038

[VipGeek]

Thanks sawbuck, If I add a database for the user autotest and I set the database name to autotest_testdb will it show up in their cpanel config? That is what I need it to do.

Thanks

[VipGeek]

OK, that does work however adding a user to that database does not work when it comes to cpanel.

[VipGeek]

I've done some searching on google and have found plenty of ways to add mysql users however they do not display properly in cpanel. Does anyone have any slight idea on how to add a database user via a backend script without going through the cpanel gui?

[VipGeek]

Does anyone have any idea?

[Infopro]

Just curious here. Why not use cPanel for this?

[webignition]

Have you tried /scripts/mysqladduserdb?

[kistler]

I've done some searching on google and have found plenty of ways to add mysql users however they do not display properly in cpanel. Does anyone have any slight idea on how to add a database user via a backend script without going through the cpanel gui?

What way do you want to do it? You can do it in ssh, and yeah I have a web "remote" way of doing it. The web way will make a database &/or user and give user rights to the database. But that would be much unsecured to have a remote system to add a database using the web

[VipGeek]

I want to be able to do it with a script, Add a database (I can easily do that) Then add a user to that database, I do not want to go into cpanel for that. I want to automate it completely.