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.
Get Sams Teach Yourself MySQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
