Installing MySQL
To Install the MySQL Server and Workbench​
The goal of this page is to demonstrate how to install MySQL Server, and a helpful tool called MySQL workbench. This guide is not an exhaustive listing of all of the various installation steps or scenarios for MySQL. For more information, take a look at MySQL's documentation: MySQL Documentation.
Go to the MySQL website at https://dev.mysql.com/downloads/mysql/
Scroll-down to Windows (x86, 32-bit), MSI Installer. You will notice multiple download options. Both allow you to install MySQL
noteMySQL Installer is 32-bit, but will allow you to install the 64-bit version of MySQL.
Click on the Download button.
On the next page, you can login or create an account if you'd like. Otherwise click No thanks, just start my download.
Running the Installer​
Once the .msi file is downloaded, run the file to begin the installation process.
The Welcome window is displayed. Select the Install MySQL Products action.
On the Choosing a Setup Type page, select Custom and click Next. While you can select one of the other options, at minimum you'll want to install both the server (the actual database) and MySQL Workbench (an application that allows you to quickly and easily interact with the database, without using a command-line client). Any other items beyond these two are generally unnecessary in most environments.
If you want to learn more, MySQL does have some additional information on their documentation if you're curious about the other options: MySQL Docs. This example will continue with a Custom installation.
On the Select Products and Features page, scroll down to choose MySQL Server 8.0. Click the right arrow to move it to the "Products/Features To Be Installed" column.
Scroll down to MySQL Workbench, select a version, and click the right arrow to move it to the "Products/Features To Be Installed" column.
Click Next.
On the Installation screen, click Execute.
After these are downloaded and installed, you see the Product Configuration page. Click Next.
In this guide, we're going to use a standalone server. On the High Availability page, select Standalone MySQL Server / Classic MySQL Replication, and click Next.
Leave the default settings on the Type and Networking page. Click Next.
On the Authentication Method page, choose Use Strong Password Encryption for Authentication. Click Next.
Create a strong password and click Next.
On the Windows Service page, leave the default settings and click Next.
On the Apply Configuration page, click Execute.
Once the configuration is applied and the database is initialized, you'll see a confirmation message. Click Finish to complete the install process.
The MySQL Workbench window is displayed. MySQL Workbench lets you to administrate the MySQL server.
Click on Local instance MySQL to connect to the newly installed MySQL server.
Enter the root password you earlier entered into the installer and click OK.
You are now connected and can see, in the Navigator, the default sys schema. Click on the Schemas tab to see a listing of schemas
A "schema" is a collection of tables and other database objects. Ignition needs a schema to connect to. Instead of using the sys schema, we can create a scheme dedicated to Ignition. To create the schema, click the Create New Schema
icon.
You'll see the Schema creation tab. This allows you to make a new Schema. Type in test as the name, and click Apply. Technically you can call the schema anything the database allows, but the default MySQL connection in Ignition assumes a schema named "test". If you name the schema something else here, you'll need to remember the name when creating the database connection in Ignition later.
You'll see the Apply SQL Script to Database window. Click Apply.
If there was an issue, the following window will state the issue. Go back and address the issue. Otherwise, click the Finish button. You should now see the test schema in the Navigator.
Now that the database is installed, you can connect Ignition to it. Learn more here: Connecting to MySQL.