I need a bash script that creates a mysql dbase without user intervention
- Статус: Closed
- Награды: $10
- Полученные заявки: 5
- Победитель: skondragunta
Краткое описание конкурса
I have set up a clean mysql install on ubuntu, and now I need to automate the process whereby what is now entered manually by the user, is automated by a script. The current steps are:
# run from bash to open the mysql terminal
sudo mysql -u root -p
# then in the mysql terminal type
2. CREATE DATABASE redmine_db;
3. GRANT ALL PRIVILEGES ON redmine_db.* TO 'redmine_user'@'localhost' IDENTIFIED BY 'password';
4. FLUSH PRIVILEGES;
The deliverable is a script which would allow us to accomplish this (steps 1 to 5) as an automated script.
In case of identical responses, THE EARLIEST POST WILL BE AWARDED THE CONTEST.
“Srivatsav is an excellent programmer. He has excellent communication skills, problem solving skills, and thorough no-corners-cut approach to programming. Thanks again for your help!”