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

Databases

Posted by Fernando Encinas
Fernando Encinas
4,218 Points

MySQL Cannot Connect to Database Server

I am following DATABASE FOUNDATIONS (which uses outdated software). I have installed mysql server and workbench, following the instructions and not changing any settings. I keep being unable to connect to server. Unfortunately this course looks a bit old and no TREEHOUSE team seems to be providing a solution for this issue.

This is what I get when trying to connect:

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

Please: 1 Check that mysql is running on server 127.0.0.1 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 127.0.0.1 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 127.0.0.1 connecting from the host address you're connecting from

Fernando Encinas
Fernando Encinas
4,218 Points

Running on OSX 10.11.6

emilosvald
emilosvald
9,701 Points

Having this same issue although I have also tried both my system password and the one provided during mySQL installation. I have tried multiple solutions suggested at Stackoverflow forums with zero results. Would love to hear a solution to this!