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!

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

vikas pal
vikas pal
11,563 Points

A problem in database

Hii everyone please see the video first from 00:00 to 08:55 and then answer to these questions First please tell me in brief what is server and host and IP address and second (also describe in brief) Why database is already in User1 and we give permission in admin and how it is granted to User1 when we created a new connection and also explain what is *'%' in the video.Please explain in brief.

1 Answer

Andrew Chalkley
Andrew Chalkley
Treehouse Guest Teacher

Imagine you have two servers a database server and web server.

Database IP :
Web Server IP :

When you set up a user user1@'%' that means the user can connect from any machine on the internet. If you did user1@'' the database user can only connect from your web server.

So you may set up different roles with different privileges to connect from different machines. Maybe read only from your search server, admin only from your local machine.