Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Installing MySQL Server and MySQL Workbench Installing MySQL Server and Workbench on OS X

How do you create a new server instance in mySQL Workbench 6.1.7?

How do you create a new server instance in mySQL Workbench 6.1.7?

5 Answers

Maximiliane Quel
PLUS
Maximiliane Quel
Courses Plus Student 55,489 Points

First you need to start the server in the terminal using this line. It only worked for me after I performed this step.

sudo /usr/local/mysql/support-files/mysql.server start

Then you can go into the workbench click on the plus sign next to MySQL Connection and fill in the parameters under connection and possibly set the installation type in System Profile from Custom to MacOS X (MySQL Package). If you have already filled out that information before starting the server and now start the server it should work too.

Thanks Guido D.! https://teamtreehouse.com/forum/would-anyone-have-a-current-reference-on-installing-the-mysql-server-and-workbench-on-osx

This worked for me….

Christian Espinoza
Christian Espinoza
4,163 Points

Adding this command to my terminal messed up everything. Now I can't start/stop mysql database from my system preferences. Any idea why?

Christian Espinoza
Christian Espinoza
4,163 Points

I got this error message "ERROR! The server quit without updating PID file (/usr/local/mysql/data/christians-MBP.pid)."

For Mac:

First go to system preferences find mysql and start the server. In workbench, what worked was clicking the + button on the upper left, next to the wrench icon and then changing the name of the connection to localhost and the hostname to localhost. Then I changed the port of the connection to 3307.

After that, I tested the connection in the server management.

Jordan Pike
Jordan Pike
5,699 Points

I find myself in the same situation. Any luck yet Alon?

nope. i just downloaded the mySQL workbench used in the video. A bit frustrating..

Jordan Pike
Jordan Pike
5,699 Points

Me too, haha! I'm sure we'll get it at some point.

Martin Mekhaiel
Martin Mekhaiel
14,297 Points

just klick on the home icon tab, then next to MySQL Connections, there is a Plus icon (+)

let me know if that helped?

regards :)