Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- PASS=$(pwgen -s 40 1)
- if [ -r /root/.my.cnf ]; then
- mysql -uroot <<MYSQL_SCRIPT
- CREATE DATABASE $1;
- CREATE USER '$1'@'localhost' IDENTIFIED BY '$PASS';
- GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost';
- FLUSH PRIVILEGES;
- MYSQL_SCRIPT
- else
- echo "Please insert the mysql root password:"
- read mysqlrootpassword
- mysql -uroot -p${mysqlrootpassword} <<MYSQL_SCRIPT
- CREATE DATABASE $1;
- CREATE USER '$1'@'localhost' IDENTIFIED BY '$PASS';
- GRANT ALL PRIVILEGES ON $1.* TO '$1'@'localhost';
- FLUSH PRIVILEGES;
- MYSQL_SCRIPT
- fi
- echo "MySQL database and user created."
- echo "Database: $1"
- echo "Username: $1"
- echo "Password: $PASS"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement