From the course: MySQL Data Analysis

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Connecting Workbench to the server

Connecting Workbench to the server - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Connecting Workbench to the server

“

- [Instructor] Okay, now that we've got Workbench installed, the next step is to connect it to community servers so we can start writing queries. 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…

Contents