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

Leave a comment