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 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.

vikas pal
vikas pal
11,563 Points

Andrew Chalkley

1 Answer

Andrew Chalkley
STAFF
Andrew Chalkley
Treehouse Guest Teacher
Andrew Chalkley
Andrew Chalkley
Treehouse Guest Teacher

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

Database IP : 192.168.0.10
Web Server IP : 192.163.100.12

When you set up a user user1@'%' that means the user can connect from any machine on the internet. If you did user1@'192.163.100.12' 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.