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

Alex Watts
Alex Watts
8,396 Points
Posted by Alex Watts
Alex Watts
8,396 Points

MySQL error?

Hello,

I got an error when trying to run a script in Workbench (see following):

'23:39:05 DROP DATABASE IF EXISTS treehouse_movie_db Error Code: 1044. Access denied for user ''@'localhost' to database 'treehouse_movie_db' 0.014 sec '

I have no idea what it means or how to fix it. Could someone explain this to and help resolve the problem.

Thanks.

2 Answers

Steven Parker
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

:point_right: The user account apparently didn't get a full set of privileges when set up.

From the DBA account:

GRANT ALL ON *.* TO 'user'@'localhost';
Alex Watts
Alex Watts
8,396 Points
Alex Watts
Alex Watts
8,396 Points

Hi Steven,

What do I do with the code you have shown me and where do I run it?

Thanks.