From the course: Advanced MySQL Data Analysis

MySQL installation overview - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

MySQL installation overview

“

- [Instructor] All right, we're almost ready to get you writing code. The last thing we need to do is download and set up MySQL Community Server and MySQL Workbench. Sometimes installing software can be challenging and a little bit frustrating. If you run into trouble, try and be patient. You may need to go through multiple times. You may need to look at the course materials and walk through the printouts in addition to walking through this video. And if you get stuck, feel free to post questions and I'll try to help you get through the setup. First, we're going to be downloading Community Server, which is what allows you to set up and host a database on your machine. Then we're going to be installing MySQL Workbench. This is the editor that allows you to write SQL queries and access that database. After we have Workbench installed, we're going to connect it to the server, and then we'll walk through the MySQL Workbench interface and show you where your queries go, how to troubleshoot errors, and where you're going to see your results. Then after we get Community Server and Workbench installed comes the fun part where we actually create the database that is going to be hosted on your machine. Don't worry, this part is super easy. I've put everything into one SQL Script, which all you have to do is run and it does all the work for you. So once you get to this step, you're pretty much home free. And one thing to note that's really important, I've listed out five steps. If you've taken one of my courses in the past and you already have Community Server and MySQL Workbench on your machine, and it's already connected, you don't need to go through steps one through four again. You should go ahead and skip over to the video that's on creating the database, and that way we'll get you writing SQL queries a lot faster. You might have a version of MySQL Workbench or Community Server that is different from my version, doesn't matter. It's going to look a little different, but you'll definitely still be able to follow along. So again, I would recommend you jump right to step five and just create the database so you can get started. Sometimes the process of installing Community Server and Workbench can be frustrating for people. So try to be patient, run through these videos multiple times if you need to, and just try to stick with it. I promise, once you get this in, the rest of the course is going to be pretty smooth and you're going to really, really enjoy it. So stick with me, get through this install, and feel free to post to the Q&A forums or message me directly if you have problems, and I will try to help.

Contents