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 Securing and Maintaining a MySQL Database Setting up Multiple Users

Posted by dim chan
dim chan
2,175 Points

can't connect user1 @localhost to treehouse_movie_db

17:20:05 use treehouse_movie_db Error Code: 1044. Access denied for user ''@'localhost' to database 'treehouse_movie_db' 0.000 sec

did make everything like in video except ip - I used default 127.0.01:3306 and grant acess to the database via local mysql instance at localhost as well.

what's wrong?

thanks for any help!

2 Answers

dim chan
dim chan
2,175 Points
dim chan
dim chan
2,175 Points

okay, did use "to user1@'127.0.0.1'" instead of "to user1@'%'"..

Brian DuVerneay
Brian DuVerneay
19,439 Points
Brian DuVerneay
Brian DuVerneay
19,439 Points

This fixed the same problem for me, so thank you!

Though I thought that using the '%' was supposed to work too?