Bash Shell Script to Create mySQL Database
Posted on 2010-11-16
I'm using a domain hosting server that runs Red Hat Linux.
I'm attempting to automate the creation of new addon domains that require a mySQL database and user with password.
Can you help me write a bash shell script that will ...
1) Create a database; the name of the database needs to be generated using the domain name as a seed word, but it must have minimal encoding as well. Something like this: mydomain > MydOM@1n
2) Create a user with password and permissions, and assign it to that database. I will need some sort of random password generator also, that will provide passwords for the user.
3) If you think Perl has better resources for this, please let me know.