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
vikas pal11,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.
Andrew ChalkleyTreehouse Guest Teacher
Imagine you have two servers a database server and web server.
Database IP : 192.168.0.10
Web Server IP : 22.214.171.124
When you set up a user
user1@'%' that means the user can connect from any machine on the internet. If you did
user1@'126.96.36.199' 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.