mysql - Create database in Shell Script - convert from PHP
I have the following PHP code that i use to create a database, a user, and grant permissions to the user:
$con = mysql_connect("IP.ADDRESS","user","pass"); mysql_query("CREATE DATABASE ".$dbuser."",$con)or die(mysql_error()); mysql_query("grant all on ".$dbuser.".* to ".$dbname." identified by '".$dbpass."'",$con) or die(mysql_error());
I want to perform these same actions but from within a shell script. Is it just something like this:
MyUSER="user" MyPASS="pass" MYSQL -u $MyUSER -h -p$MyPASS -Bse "CREATE DATABASE $dbuser;" MYSQL -u $MyUSER -h -p$MyPASS -Bse "GRANT ALL ON $DBUSER.* to $DBNAME identified by $DBPASS;"
EDIT as this is needed within postwwwacct (a cPanel post account creation hook script) ideally it will be entirely self-contained
You need to lower-case "MYSQL" and add a hostname after the
-hand you've mixed single and double quotes. Also, you need to set the values for
dbpassand use consistent capitalization.:
But I'm not 100% confident in your SQL syntax. I would think it would look more like this:
Your quotes and capitalization is a bit off (or platform biased), but in essence yes.
You might want to consider actually having your script create an sql script, then making it run through php, shell(s!), etc will be much easier.