Return to Snippet

Revision: 53607
at November 29, 2011 13:41 by jiewmeng

Initial Code
echo "Creating user: $1"
PASSWD=`makepasswd --char=8`
echo "Password: $PASSWD"
sudo useradd $1 -d "/var/www/$1" -g devs -m -p "$ENPASSWD"

echo "Creating mysql user & database for $1"
mysql -u root --password=km123 -e "CREATE DATABASE $1; CREATE USER $1 IDENTIFIED BY '$PASSWD'; GRANT ALL ON $1.* TO '$1'"

Initial URL

Initial Description

    > newuser.bash [username]

**What it does**

- Generates a random password with `makepasswd`
- Encrypts it with `mkpasswd` for use with useradd
- Adds the user
- Adds a MySQL Database for user
- Adds a MySQL User for user
- Grants all privileges to user to his/her database

**Sample Output**

    [email protected]:~$ ./newuser.bash test1
    Creating user: test1
    Password: zV8MDMRh
    [sudo] password for km: 
    Creating mysql user & database for test1

[Short demo on Screenr (1min)](

Initial Title
Create Linux User with Geneated Password and MySQL User

Initial Tags
mysql, linux, user

Initial Language