Setting up MySQL for easy integration with Warewolf

Warewolf has many database connectors, which makes integrating with Warewolf effortless and efficient. In this blog we are going to bring you step by step instructions on how to download and setup MySQL for Warewolf.

To Download and Install MySQL for Windows, the simplest and recommended method is to download the MySQL Installer and let it install and configure all of the MySQL products on your system.

Installing MySQL

Step 1: Click on the link to download the MySQL Installer.

http://dev.mysql.com/downloads/installer/

warewolf blog - mysql - download mysql installer

Step 2:

  • If you have an active online connection while running the MySQL Installer, choose mysql-installer-web-community file and click download.
  • If you do not have an online connection while running the MySQL Installer, choose the myslq-installer-community file and click download.

warewolf blog - mysql - download

Step 3: To begin your download you will be prompted to Login or Sign Up to MySQL. If you have already have an account, add in your credentials and login, or skip this step this and click “No Thanks, just start my download”.

warewolf blog - mysql - start download

Step 4: Click Save, select the location in which you want to save the File and click Save again.

warewolf blog - mysql - save file

Step 5: Select the MySQL installer from the Folder in which you saved it, and double click to start the installer.

Step 6: When the file opens, click Run.

warewolf blog - mysql - run

Step 7: Follow the MySQL Installer Wizard.

Click in the check box to accept the license terms and click Next.

warewolf blog - mysql - license agreement

Step 8: Select your setup type. For the purpose of this blog, we will leave the Default Developer as the setup type and click Next.

warewolf blog - mysql - choose setup type

Step 9: Once you have selected your Setup Type, the installer will check the requirements needed to run MySQL. These will need to be resolved prior to installing MySQL. Click Next.

warewolf blog - mysql - check requirements

Step 10: Click Execute.

warewolf blog - mysql - installation ready to download

When the installation is complete and ready to be configured, the status will change to complete and a green indicator will appear on the left, as shown in the screenshot below.

Click Next.

warewolf blog - mysql -installation complete

Step 11: Click Next to configure your MySQL Server.

warewolf blog - mysql - configuration wizard

 

Step 12: Setup your Server Configuration Type and Connectivity and Click Next.

warewolf blog - mysql - type and networking

Step 13: Enter a MySQL Root Password.

warewolf blog - mysql - accounts and roles

Step 14: Create a MySQL account for your users and applications.

Click Add User. Specify the Username, Database Role and set the Password.

Click OK.

warewolf blog - mysql - add user

Click Next to move on to the next step.

Step 15: Configure MySQL Server as a Windows Service to your specific needs and click Next.

warewolf blog - mysql - window service

Step 16: You can now select how you would like to connect to the server using the Plugins and Extension Settings. Once you have set this up, click Next.

warewolf blog - mysql - plugins and extensions

Step 17: To apply the configurations, Click Execute.

warewolf blog - mysql - execute the server configuration

Step 18: Once your Configurations have executed, click Finish.

warewolf blog - mysql - finish

You can continue with the configurations or you can exit the wizard at any point from here.

We will continue to configure the Sample and Examples.

Step 1: Lets start the product configuration by clicking next.

warewolf blog - mysql - samples and examples

Step 2: Enter the credentials for the Root User, set up during the Server Configuration. Click Check. If the connection is successful a green tick will appear. Click Next.

warewolf blog - mysql - connect to server

Step 3: Apply the server configuration by clicking Execute.

Step 4: Once the configuration is successful and has stopped, click Finish.

warewolf blog - mysql - apply server configuration

The Production configuration is now complete, click Next.

warewolf blog - mysql - product configuration

Step 4: The installation and configuration is now complete. Click Finish to close the Installer.

warewolf blog - mysql - installation complete

MySQL is now setup and ready to use. You can connect to your MySQL Database using the MySQL connector tool inside Warewolf.

You can read more about adding a new database source from our Knowledge base: Adding a New Database Source.

Warewolf has many different database connectors. For help with setting up a different database click on the links below.

MS SQL Server Express

ODBC

Oracle – Coming Soon

PostgresSQL – Coming Soon

 

FacebookTwitterLinkedInGoogle+RedditEmail

1 Comment

  1. Klaudia

    Great lesson. Look forward to Oracle and PostgreSQL connection!

    – Klaudia

Leave A Comment?