postwwwacct - set privleges on new database

[willsmelser]

I was able to use the hook script:

/scripts/postwwwacct

without a problem.

In my script I create and populate a couple of databases (via php) with:

shell_exec('mysql < /path/to/mydbs.sql'); 

However, I need to access the

mysql.db table

on localhost to set premissions so the databases will be available for new user. I cannot use

mysql_connect('localhost','root','pass'); 

The connection fails. I cannot see how to do this via PHP. I am looking at Bash right now. Just rather have it all working in one language.

NOTE:

I dont like having my root password in a file like this anyway. So a better solution would be great.

[willsmelser]

well, Ive been messing with this for hours when I finally posted, and of course minutes later I got a command line solution.

user the '-e' parameter

mysql -e "USE mysql;INSERT INTO db (User,Host,Db,Insert_priv,etc....) VALUES ('newuser','localhost','newuser_basedata','Y',etc....)"

I should be able to roll that into the php shell_exec() method.

NOTE:This will work when logged in as root. Look at -u, -p or --user=, --pass= for non root implamentation.