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 firstname.lastname@example.org.
6:39Connecting to MySQL
5:56Connecting to Microsoft SQL Server Express
5:11Creating a SQLite Connection
Take topic challenge
See a walk-through of downloading and installing MariaDB.
Video recorded using: Ignition 8.1
Transcript(open in window)
[00:00] In this lesson, we'll install a MariaDB. So here I have an installer for MariaDB on Windows, which I obtained from MariaDB's download page. In this case, I'm just using the community server edition. For more details on installing or using the other versions of the database, Take a look at MariaDB's docs. Now, since I already have the installer downloaded, I'm just going to double click on it to get it running. And I'll click around here and that should start the wizard. So we'll go ahead and click Next to move forward. Take a look through the licensing agreements. I'm just going to hit Accept here and then click Next. And here we can see all of the various features that are going to be installed. I do wanna call out HeidiSQL here, which is an additional tool that we can use to modify or manipulate content within the database. Technically it's optional, but I'm going to leave it alone since you might find it useful later on. I'll click Next here. And we do need to specify a password for our root user so the database is going to have an initial user, and we wanna give that user a password here.
[01:07] So I'll just type something in. It goes without saying, but make sure you remember this password. You'll need it later. Now I'll click the Next button. I'm going to leave the service name alone, MariaDB is fine. On my local system here, I actually have a MySQL database that's using port 3306. So I'm just going to change this to 3307 and click Next. And we'll click the Install button to begin. We'll let the installer do its work. And we can see in the upper left-hand corner, HeidiSQL now has a desktop icon, which we'll reference in a moment. All right and we're finished. So I'll click the Finish button. So the database was installed and is running on my local system. However, let's go ahead and use HeidiSQL there to take a look at it. So I'm going to double click this icon here. So HeidiSQL is actually a tool that can be used to connect to different types of databases. So in this case, we need to tell Heidi which database to connect to.
[02:05] So we can start with this initial session name here, which is basically credentials and information for our particular database instance we're going to connect to. I can leave the host name alone, that's fine. For the user, we'll use the root user that was created during the MariaDB installation process. We'll type in the password for them. And I'm going to change my port, again, I used port 3307. If you didn't change your port, then just leave it alone. We can click Save down here, which basically saves this information so that we can reconnect to this database again later. And I'll go ahead and click Open. And then we should see something like this. Now, when you install MariaDB, it gives you a bunch of different databases that are called, which are basically collections of tables. If I click on one of these, we can see all the contents. And actually, I guess it's more than tables. It's different objects too. So there's a couple of different databases. These ones that are here are generally used by the database in some way.
[03:03] It's usually a good practice to not use those for things like Ignition or third-party applications. It's usually a good idea to add a dedicated database for those applications. So what I'm gonna do is because I didn't give it a name, it's titled Unnamed, I'm going to right click on it, I'm going to create new database. And this is just for testing and playing around. So I'm just gonna call this test, but of course we could give this a more useful name if we want to. You can call it Ignition or what have you. Whatever you end up calling this later on, when you're creating a connection from Ignition to this database, this is the name we'll use. But I'll leave it with test for now and I'll click OK. And there we are, we have our test database here. It doesn't really have too much inside of it right now, but that's fine. Later on when we connect Ignition to this database here, Ignition will be able to automatically start creating tables and populating content inside of here. Okay, that about wraps up this video here. We now have a running copy of MariaDB running on our local system.