I need a bash script that creates a mysql dbase without user intervention

Status: Closed
Prize: $10
Entries Received: 5
Winner: skondragunta

Winner

Contest Brief

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
1. password
2. CREATE DATABASE redmine_db;
3. GRANT ALL PRIVILEGES ON redmine_db.* TO 'redmine_user'@'localhost' IDENTIFIED BY 'password';
4. FLUSH PRIVILEGES;
5. exit;

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.

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“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!”

heritagesociety, Australia.

Top entries from this contest

skondragunta India

0
sreeshiningstar India

0
blui88 India

0
blui88 India

0
notgreen Hungary

0

View More Entries

Public Clarification Board

Contest Holder
- 4 years ago
Thanks everybody, a really helpful set of suggestions, and I do really appreciate your feedback. If I could split the loot I'd to that, but I cannot so I have to make a hard decision. Thanks again, and hopefully we will work again. Alex
- 4 years ago
1. blui88
  - 4 years ago
  Hi,
  Congratulations for choosing the best fit solution for your work.
  Thanks for your kind appreciation and kind support.
  With regards
  Santosh
  - 4 years ago
blui88
- 4 years ago
#increaseprize #increaseprize
- 4 years ago
blui88
- 4 years ago
Hi there,
see entry #1 ,hope it will work for you.
Let me know if you face any kind of issue.
Regards
Santosh
- 4 years ago