Administration Guide › Provisioning Resources › Service Provisioning › How to Deploy a Wiki Web Page › Define Applications for Wiki › Define MySQL

Define MySQL

MySQL is the server on which your wiki database will be running.

Follow these steps:

1. Click Resources, and in the Explore tree, right-click OnDemand Services, and select New Application.

   The Define an Application wizard opens in the Application Details panel.

2. Specify the Name, Version, and Vendor for the application.
3. Specify the location of the application files (absolute path or relative to the Staging folder).
4. Click Next.

   The System Requirements panel opens.

5. Set the following recommended values:
   • Number of CPUs – 1
   • Memory – 512 MB
   • Disk Space – 5 GB
   • Operating System – All Microsoft Windows Server versions
6. Click Next.

   The Configure Installation Actions panel opens. You will define three installation actions: Install MySQL, Configure MySQL, and Grant Permissions to Root.

7. Click + to define the Install MySQL action.
   1. On the Select Installation Action panel, in the Action field, input the command to execute:

      msiexec
      

   2. Enter a description for the action.
   3. Click Next.
   4. On the Define Installation Action Options panel, add the following three options:

      /i %CD%\mysql-5.5.25-winx64.msi
      

      /passive
      

      INSTALLDIR=C:\MySQL
      

   5. Make the INSTALLDIR option user editable.
   6. Click Finish.

      The action is saved.

8. Click + to define the Configure MySQL action.
   1. On the Select Installation Action panel, in the Action field, input the command to execute:

      cmd
      

   2. Enter a description for the action.
   3. Click Next.
   4. On the Define Installation Action Options panel, add the following options:

      /C C:\MySQL\bin\MySQLInstanceConfig.exe -i -q "-lC:\mysql_install_log.txt" "-nMySQL Server 5.5" "-pC:\MySQL" -v5.5 "-tC:\MySQL\my-template.ini" "-cC:\mytest.ini" ServerType=DEVELOPMENT DatabaseType=MIXED ConnectionUsage=DSS Port=3306 ServiceName="MySqlD" 
      

      RootPassword=pass
      

   5. Make the RootPassword option user editable.
   6. Click Finish.

      The action is saved.

9. Click + to define the Grant Permissions to Root action.
   1. On the Select Installation Action panel, in the Action field, input the command to execute:

      cmd
      

   2. Enter a description for the action.
   3. Click Next.
   4. On the Define Installation Action Options panel, add the following options:

      /C C:\MySQL\bin\mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'Root'@'localhost' IDENTIFIED BY 'pass';"
      

      --password=pass
      

   5. Make the password option user editable.
   6. Click Finish.

      The action is saved.

10. Click Next, and then Finish.

    The MySQL application is saved.