Summary

Today you learned about security on a MySQL server. You learned the principles of the user privilege system and saw that you can use it to not only authenticate users with their passwords but also to base the level of privilege on the host from which the user is connecting. On the basis of these three parameters, privileges can be granted globally, or for a specific database, table, or columns. This allows you to set up some users with wide-ranging privileges, and others with their privileges limited to a database or part of it.

You learned how to use the GRANT, REVOKE, and SHOW GRANTS commands to manage user privileges. Finally, you saw how to use MySQL to make secure connections.