RE: [cobalt-users] [RAQ550]Automatic mysql user creation

["Bob Lenaerts" <bob@xxxxxxxxxx>]

Webmin does this very fine :)

bob

-----Original Message-----
From: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx] On Behalf Of Arthur Sherman
Sent: maandag 29 maart 2004 2:11
To: cobalt-users@xxxxxxxxxxxxxxx
Subject: RE: [cobalt-users] [RAQ550]Automatic mysql user creation


> 
> Found this on the net some time ago.  It sets things up
> nicely and even works with phpMyAdmin.
> 
> tput clear
> echo "*****************************************"
> echo "  MySQL Database Creator"
> echo -e "*****************************************\n\n"
> echo "This script will create a MySQL database."
> echo "The DATABASE will be named after the USERNAME."
> echo -e "Please supply the USERNAME and PASSWORD for the new
> database.\n"
> 
> echo -n "Username: "
> read username
> 
> echo -n "Password: "
> read password
> 
> echo -e "\nThe following database will be created:"
> echo "DATABASE: $username"
> echo "USERNAME: $username"
> echo "PASSWORD: $password"
> 
> echo -e "\n\nNow i need the root password to enter MySQL" echo -n 
> "Password to enter MySQL: " read rootpassword
> 
> mysql -u root -p$rootpassword -e"INSERT INTO user
> (host,user,password) VALUES 
> ('localhost','$username',Password('$password'));" mysql mysql 
> -u root -p$rootpassword -e"INSERT INTO db 
> (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,
> Create_priv,Dr
> op_priv,Alter_priv,Index_priv) VALUES
> ('localhost','$username','$username','Y','Y','Y','Y','Y','Y','
> Y','Y');"
> mysql
> mysqladmin -u root -p$rootpassword create $username 
> mysqladmin -u root -p$rootpassword reload
> 
> echo -e "\n\nIf no error appeared, the database is setup correctly."
> 
Can it be installed into GUI? 

Arthur Sherman