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

  • Durum: Closed
  • Ödül: $10
  • Alınan Girdiler: 5
  • Kazanan: skondragunta

Yarışma Özeti

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.

Tavsiye Edilen Beceriler

İşveren Geribildirimi

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

Profil Görüntüsü heritagesociety, Australia.

Bu yarışmadan başlıca girdiler

Daha Fazla Katılım Görüntüle

Genel Açıklama Panosu

  • heritagesociety
    Yarışma Sahibi
    • 1 ay önce

    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

    • 1 ay önce
    1. blui88
      blui88
      • 1 ay önce

      Hi,
      Congratulations for choosing the best fit solution for your work.
      Thanks for your kind appreciation and kind support.
      With regards
      Santosh

      • 1 ay önce
  • blui88
    blui88
    • 1 ay önce

    #increaseprize #increaseprize

    • 1 ay önce
  • blui88
    blui88
    • 1 ay önce

    Hi there,
    see entry #1 ,hope it will work for you.
    Let me know if you face any kind of issue.
    Regards
    Santosh

    • 1 ay önce

Yarışmalara nasıl başlanır

  • Projenizi ilan edin

    Yarışmanızı İlan Edin Hızlı ve kolay

  • Tonlarca girdi alın

    Tonlarca Girdi Alın Bütün dünyadan

  • En iyi girdiyi seçin

    En iyi girdiyi seçin Dosyaları indirin - Kolay!

Şimdi bir Yarışma İlan Et ya da Bugün Bize Katılın!