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 jitendra goyal
jitendra goyal
3,752 Points

When im trying to test the connection for the admin remote db connection I am unable to connect to it.

Your connection attempt failed for user 'admin' from your host to server at 127.0.0.1:3306: Access denied for user 'admin'@'localhost' (using password: YES)

Please: 1 Check that mysql is running on server 127.0.0.1 2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed) 3 Check the admin has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines) 4 Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting from

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

It looks like you are trying to connect to localhost not a remote database?

3 Answers

Javid Abbasov
Javid Abbasov
9,243 Points
Javid Abbasov
Javid Abbasov
9,243 Points

i also have this problem

Alzira Barretto
PLUS
Alzira Barretto
Courses Plus Student 13,089 Points
Alzira Barretto
Alzira Barretto
Courses Plus Student 13,089 Points

I also have the same problem. Hope someone can solve it and I would be happy

Livia Dobai
Livia Dobai
21,894 Points
Livia Dobai
Livia Dobai
21,894 Points

Hi! I found the first fart of the video when he connects to a remote server using the admin user a little confusing, because i have only a local database with the root user set up. Fortunately forlorn to create users you can use this connection. Don't need the admin user at all. You can proceed from the 4:30 on the video.