mysql user creation script

tanveer · 06-19-2007, 10:17 AM

Hi all,

How to run a script with all the commands of a user creation in mysql server 4.1.7 ?

Like I have to create a users in my PC and I want creat a script for that. The commands i use to creat a user is as follows:

Code:

GRANT SELECT(name,fname) on 'test`.`sample` to 'bob'@'localhost';
flush privileges;
UPDATE mysql.user set Password=PASSWORD('dummy') where user='bob' and Host='localhost';
flush privileges;

Now how to make a script so that whenever I run the script it will create the user using these 4 commands.

Thanks in advance.

tanveer · 06-19-2007, 11:02 PM

Done. Thanks

p_s_shah · 06-20-2007, 01:21 AM

Update us how did you achieve it.

IF i suppose to do :

Code:

[root@example root] cat dbuser_create.sh
# Information for connecting to mysql for running GRANT queries.
DBHOST=localhost
DBUSER=root
DBPWD=abc123
CMDFILE=usercreate.sql

# Gathering info for setting up GRANT queries.
echo "Enter Username"
read USERNAME
echo "Enter Password"
read USERPWD
echo "Enter DB"
read USERDB
echo "Enter Table"
read USERTBL

# Delete old file
rm -f $CMDFILE

# Creating File which contains SQL query
echo -e "GRANT SELECT(name,fname) on $USERDB.$USERTBL to $USERNAME@'localhost';\nflush privileges;\nUPDATE mysql.user set Password=PASSWORD($USERPWD) where user=$USERNAME and Host='localhost';\nflush privileges;" >> $CMDFILE

# Running query through mysql.
mysql -u $DBUSER -p`$DBPWD' $DBHOST < $CMDFILE

Add checking for USERNAME,USERPWD etc.