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

Marta Dias
Marta Dias
9,240 Points
Posted by Marta Dias
Marta Dias
9,240 Points

Installing MySQL server trouble.

I'm doing DataBase Foundations. I have a later version from the one in the video, in fact they no longer promote the same version as the video. I'm having troubles making the connection.

It says: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at localhost:3306: Access denied for user 'root'@'localhost' (using password: NO)

Any help? Can you update your database courses?

Sue Dough
Sue Dough
35,800 Points
Sue Dough
Sue Dough
35,800 Points

Where are you seeing this error and what are you doing when you see it?

Also what are you using phpmyadmin, workbench, or shell ?

2 Answers

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,253 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points

Check out the video in which Andrew goes through the installation. I believe he provides the files for the version of the installation used in the course. I did try to go for the latest version myself but I ran into similar problems. Luckily so far 5.6 is the only version i've needed so far.

Marta Dias
Marta Dias
9,240 Points
Marta Dias
Marta Dias
9,240 Points

The video I watched is an old one. I'm doing it still, as it helps, just wanted a full understand in what to do in that situation. I'll give it another try.

jason chan
jason chan
31,009 Points
jason chan
jason chan
31,009 Points

If you have xampp installed.

WINDOWS though.

For the workbench only install the workbench client make sure the xampp control panel is on for the apache and mysql server.

That's how i followed a long.

If not your going to have to uninstall all your mysql servers and try to do a clean install.

Marta Dias
Marta Dias
9,240 Points
Marta Dias
Marta Dias
9,240 Points

I'm a Mac user.

I thought about. maybe there's some conflict with old servers or something.

cheers.