MySQL Creating User Account


#!/bin/bash

Create a full user account
/usr/sbin/useradd -m -k /home/template -g apache $1
echo “$2” | /usr/bin/passwd –stdin $1
chmod 750 /home/$1
echo “create database $1; GRANT all on $1.* to $1@’localhost’ identified by ‘$2′” | \
/usr/local/mysql/bin/mysql -hlocalhost -uroot -p$3
echo “set password for ‘$1’@’localhost’ = OLD_PASSWORD(‘$2’)” | \
/usr/local/mysql/bin/mysql -hlocalhost -uroot -p$3

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s