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

Ruby ActiveRecord Basics Migrations and Relationships Migrations

Mike Pallas
Mike Pallas
12,246 Points
Posted by Mike Pallas
Mike Pallas
12,246 Points

mysql access denied [ERROR 1045] (Windows 8)

I'm (attempting) the migrations lesson in the ActiveRecord class, and I've run into an error I can't get around.

I've gotten right past the part where we do rake db:create (after struggling and spending a bunch of time getting that to work).

Now when I try mysql -u root I get this error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N O)

I've spent a few hours searching for a bunch of possible solutions that ultimately didn't work, and I have no idea where to go from here.

I'm on Windows 8.1 64-bit, running MySQL Server 5.6, Rails 4.1.6, and Ruby 1.9.3p545

Thanks in advance.

Mike Pallas
Mike Pallas
12,246 Points
Mike Pallas
Mike Pallas
12,246 Points

Of course, as soon as I post this question I try mysql -u root -p and have it work.

I'm not sure if that -p was the only mitigating factor to it not working before, but I seem to have it going now. Though, I would still welcome any insights into what was going wrong earlier.

Gavin Ralston
Gavin Ralston
28,770 Points
Gavin Ralston
Gavin Ralston
28,770 Points

I'm sure you're past this point now (looks like you asked quite a while ago)

But, yeah, it was the -p flag that was holding you up. :)