create database from shell script

[ekitel]

I'm trying to use a shell script on my dedicated server to create new databases

 

here's my shell script

 

#!/bin/sh
mysql -u root -e "create database $1";
mysql -u root -e "GRANT ALL ON $1.* TO user_name@localhost" $1;

 

when I log into the shell with ssh as 'root' and run this script the first line works and creates the database, the second line that's supposed to grant permission to an existing user does not work

 

when I try to execute the script from PHP with this command neither of the 2 lines work:

 

exec($_SERVER["DOCUMENT_ROOT"]. "/scripts/create_db.sh $new_db_name");

 

any idea what I'm doing wrong? thanks in advance!

 

[fenway]

Really? Root via SSH? Scary....