Let's keep the start MySQL Workbench after setup box checked and click finish. On the product configuration page, go ahead and click next, and we'll see a message saying the installation's complete. Once configuration is complete you should see a confirmation message notifying you that configuration was successful. We'll leave the default settings on the Windows service page and click next, and we can click execute on the apply configuration page. After we've entered a strong password, we'll click next. On the accounts and roles page, we'll need to enter a password for the root account. On the authentication method page, click the use strong password encryption for authentication method, and click next. We'll leave the default settings on the type and networking page and click next. On the product configuration page, click next. Now, that the products are installed, we can go ahead and click next. We'll expand applications, MySQL Workbench, MySQL Workbench 8.0, click our version, click the arrow, click next. We'll also add MySQL Workbench to the to be installed section, so that we can manage our database via a graphical user interface. Once a version is selected, click the arrow to move it to the to be installed section. We'll expand the MySQL's servers, and choose a MySQL server eight version to install. Now, we can choose the products and features to install. After running the installer, you'll be taken to the choosing a setup type window. Now, MySQL is installed and ready to be connected with Ignition. You should be able to see the test schema within the navigator. Next page here, we'll go ahead and click finish. You'll see the apply SQL script to database window. After entering the name test, go ahead and click apply. So, that's what we'll name the new schema. The default MySQL connection in Ignition assumes a schema named test. Within the schema section, right click some blank space and we'll click create schema. Towards the bottom of the pane, you'll see some tabs, one that says administration, and one that says schemas. On the left side of the window, you'll see the navigator pane. Once logged in you could administer your database instance. After hitting okay, we'll be logged into our database instance. So, from here we'll be prompted to enter that password that we entered for the root user in the installation process. Let's click on the local instance of MySQL. Now, the MySQL Workbench window will be displayed. Once the file is downloaded, we can run it and begin the installation process.Īfter running the installer, you'll be taken to the choosing a setup type window. We can click, no, thanks, just start my download. The next page will ask if we wanna log in with an existing account or sign up for an Oracle web account. You'll notice the installers are 32-bit, but they will allow you to install the 64-bit version of MySQL. Both will allow you to install MySQL, so I'll choose the top one. So, let's click the go-to download page button. 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. The community version is a free downloadable version, supported by open source developers and enthusiasts. Let's start by heading to the download page for the community version of MySQL. In this video, I'll show you how to install MySQL and set it up, so that's ready to connect to Ignition.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |