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

Becky Castle
Becky Castle
15,294 Points

Unable to "connect to host machine" in mySQL workbench

My predicament is identical to a previous post, HOWEVER...

I followed the advice given in the first comment, and </br> <ol> <li>1. setup a new connection </li>

<li>2. changed both the connection & host name to "localhost" as Andy had done in the video</li>

<li>3. clicked "configure server management" and continued through all of the tabs</li> </ol>

It seemed to working out ok UNTIL I got to "test settings" -- apparently I am unable to "connect to host machine". (I did get green checkmarks for the other two stipulations listed.)</br>

Why am I unable to connect to my host machine? Do I need to install MAMP or XAMP?

3 Answers

If you are using localhost aka a server on your machine you need to install xamp, wamp, mamp depending on what OS you are using.

In the MySql Utilities menu, check to see that the server is started. To get there, start menu, mysql, utilities.

Becky Castle
Becky Castle
15,294 Points

Sorry for my delayed response --- thanks for your help, you guys! I THINK it's working, now that I installed Xampp and got the MySql db running from there. (I guess only true use of this program will show if it's in working order-- and for that I need to delve into more courses, lol!)
Thanks again!