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

Sam Prendiville
Sam Prendiville
911 Points
Posted by Sam Prendiville
Sam Prendiville
911 Points

Root password?

Hi William, when I try to create a localhost new server instance profile on MySQL Workbench it asks for a root password to connect to the following server, how do I find out what my root password is, can i create one?

Thanks William Sam

2 Answers

Greg Kaleka
Greg Kaleka
39,021 Points
Greg Kaleka
Greg Kaleka
39,021 Points

If you haven't set up a root mysql user before, you might try a blank password. I believe that is the default. If that does not work, you may need to reset the root password, which is not a particularly fun thing to do if you're not comfortable on the command line. Give the blank password a try, and if that doesn't work, we'll go from there!

Cheers :beers:

-Greg

Larry Liu
Larry Liu
3,127 Points
Larry Liu
Larry Liu
3,127 Points

I'm stuck on this too and a blank password isn't working for me. When I installed mysql.5.7.16-osx10.11-x86_64 it gave me a password for root@localhost. This password doesn't seem to work when I enter it in. Instead, it gives an error about ALTER USER.

Greg Kaleka
Greg Kaleka
39,021 Points
Greg Kaleka
Greg Kaleka
39,021 Points

What's the error, and what's leading up to it? An ALTER USER error sounds like you might be trying to modify the password rather than enter it... or something - not sure :blush:

Sarah Lehnert
Sarah Lehnert
9,405 Points
Sarah Lehnert
Sarah Lehnert
9,405 Points

I am having the same issue. I can't connect to the server and I think it is because I have an invalid password. I have no idea how to reset it thoughj