From the course: Advanced MySQL Data Analysis

Connecting Workbench to the server - MySQL Tutorial

From the course: Advanced MySQL Data Analysis

Start my 1-month free trial Buy for my team

Connecting Workbench to the server

“

- [Instructor] All right, now that we've got MySQL Community Server and MySQL Workbench installed, the next step is to connect Workbench to the server. Again, it's important to note that if you've taken one of my other courses, and you already have MySQL Community Server and Workbench installed, and already have a live connection, you can just skip over this step. There's no need to go in and create a new connection, so save your time and jump ahead to the Create the Database video. For everyone who does need to set up a connection, let's get started. Go into your Applications folder, and find the MySQL Workbench icon. Click into that. The first time you open Workbench, you may have a connection here under MySQL Connections. If you do, that's great. If you don't, not a big deal either. I'm actually going to delete my default connection so that I can show everyone how to create a new connection from scratch. I'm going to go ahead and click in here and delete that connection. And I'm going to start a new connection from scratch. Next to MySQL Connections, there's this plus icon. I'll click into that. The New Connection setup screen is mostly pre-configured. Your host name and your port are already in there. The most important things that you should look at are the username. You're going to want to make sure that says "Root". And then, you're going to need to add a connection name. The connection name that you add, doesn't really matter what you call it. I'm going to name mine "Mavenmovies", but you could call it anything you want. We're not going to use the connection name in any of our queries, so really this part doesn't matter, it just has to have a name. Go down here and click OK. Now we've got our connection here. When I click into that, you'll see I'm prompted to enter the password for the root user. This is the password that I asked you to remember or write down from the Community Server install section. Hopefully you did that, and you can enter it now. If you don't have that password, unfortunately you're going to need to uninstall Community Server, and you're going to need to go back to the installation video for Community Server, reinstall that, set a new password, and make sure that you note it this time. So once you've got that password, go ahead and put it in, and then click OK. This is the MySQL Workbench Editor. This is where we're going to be living for most of the course.

Contents