Day 14. Security

Today you will learn about security on a MySQL server. MySQL has a powerful security system that can create globally powerful users or precisely control their privileges.

In particular, you will learn:

  • How the MySQL privilege system works

  • How to set up and manage database users using GRANT, REVOKE, and SHOW GRANTS

  • How to set up some typical users and their privileges

  • How to exercise good practices to keep your MySQL installation secure

  • How to configure your MySQL server to use 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.