You can help by commenting or suggesting your edit directly into the transcript. We'll review any changes before posting them. All comments are completely anonymous. For any comments that need a reply, consider emailing training@inductiveautomation.com.
Version:
LESSON LIST
-
6:39Connecting to MySQL
-
6:33Connecting to Microsoft SQL Server Express
-
5:11Creating a SQLite Connection
Take Topic Challenge
Supplemental Videos
LESSON
Installing MySQL
Description
See a walk-through of downloading and installing MySQL Community Edition. Both the database and MySQL Workbench will be installed.
Video recorded using: Ignition 8.1
Resources
Transcript
(open in window)[00:00] In this video, I'll show you how to install MySQL and set it up, so that's ready to connect to Ignition. Let's start by heading to the download page for the community version of MySQL. The community version is a free downloadable version, supported by open source developers and enthusiasts. I'll include the URL on the screen now. I'm on a Windows machine, so I'll run through the steps to get set up in Windows, but there are installers available for Linux and Mac OS as well. We'll download the MSI file. So, let's click the go-to download page button. From here, there are multiple options. Both will allow you to install MySQL, so I'll choose the top one. You'll notice the installers are 32-bit, but they will allow you to install the 64-bit version of MySQL. Click download. The next page will ask if we wanna log in with an existing account or sign up for an Oracle web account. We can click, no, thanks, just start my download. Once the file is downloaded, we can run it and begin the installation process.
[01:08] After running the installer, you'll be taken to the choosing a setup type window. Select custom and click next. Now, we can choose the products and features to install. We'll expand the MySQL's servers, and choose a MySQL server eight version to install. Once a version is selected, click the arrow to move it to the to be installed section. We'll also add MySQL Workbench to the to be installed section, so that we can manage our database via a graphical user interface. We'll expand applications, MySQL Workbench, MySQL Workbench 8.0, click our version, click the arrow, click next. We'll click execute. Now, that the products are installed, we can go ahead and click next. On the product configuration page, click next.
[02:06] We'll leave the default settings on the type and networking page and click next. On the authentication method page, click the use strong password encryption for authentication method, and click next. On the accounts and roles page, we'll need to enter a password for the root account. After we've entered a strong password, we'll click next. We'll leave the default settings on the Windows service page and click next, and we can click execute on the apply configuration page. Once configuration is complete you should see a confirmation message notifying you that configuration was successful. Click finish. On the product configuration page, go ahead and click next, and we'll see a message saying the installation's complete. Let's keep the start MySQL Workbench after setup box checked and click finish. Now, the MySQL Workbench window will be displayed.
[03:06] Let's click on the local instance of MySQL. So, from here we'll be prompted to enter that password that we entered for the root user in the installation process. After hitting okay, we'll be logged into our database instance. Once logged in you could administer your database instance. On the left side of the window, you'll see the navigator pane. Towards the bottom of the pane, you'll see some tabs, one that says administration, and one that says schemas. Click the schema's tab. Within the schema section, right click some blank space and we'll click create schema. The default MySQL connection in Ignition assumes a schema named test. So, that's what we'll name the new schema. After entering the name test, go ahead and click apply. You'll see the apply SQL script to database window.
[04:04] Go ahead and click apply again. Next page here, we'll go ahead and click finish. You should be able to see the test schema within the navigator. Now, MySQL is installed and ready to be connected with Ignition.