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

Giovanni Valdenegro
Giovanni Valdenegro
13,871 Points
Posted by Giovanni Valdenegro
Giovanni Valdenegro
13,871 Points

I cannot start the local instance of MySQL Workbench ver. 6.1??

This video shows how to install MySQL server and Workbench older version on a MAC. I tried opening the MySQL Workbench 6.1, and I don't see how to create an instance of the DB. I tried loggin in and I get a error saysing:

Your connection attempt failed for user 'root' from your host to server at localhost:3306: Access denied for user 'root'@'localhost' (using password: YES)

Please: 1 Check that mysql is running on server localhost 2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed) 3 Check the root has rights to connect to localhost from your address (mysql rights define what clients can connect to the server and from which machines) 4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from

Need help thanks.....

3 Answers

Samuel Rueby
Samuel Rueby
22,538 Points
Samuel Rueby
Samuel Rueby
22,538 Points

Well, the first thing I would check is if the MySQL database is running. I don't have a mac, but you should be able to run a command like "ps aux | grep mysql" at the command line. If it shows a line with mysql and its PID and such, it's running. If it's running and you can't log in, then i would guess the password is incorrect.

Giovanni Valdenegro
Giovanni Valdenegro
13,871 Points
Giovanni Valdenegro
Giovanni Valdenegro
13,871 Points

I rand the command Samuel and it is running..

I have MAMP installed with MySQL PHPMyAdmin installed already maybe there is a conflict. I guess I should just use the phpMyAdmin, any of you know if it makes any difference for this project, if I go this route. Is there anything I would be missing out on?

Thanks.

Samuel Rueby
Samuel Rueby
22,538 Points
Samuel Rueby
Samuel Rueby
22,538 Points

You're able to login without a problem to PHPMyAdmin? If that works, I don't think there will be a problem.