Database Reference
In-Depth Information
CHAPTER 23
Security
23.0. Introduction
This chapter covers security-related topics:
• The
mysql.user
table that contains MySQL account information
• Statements for managing MySQL user accounts
• Password strength checking and policy
• Password expiration
• Finding and fixing insecure accounts
• Finding and removing anonymous accounts and accounts that permit connections
from many hosts
If you like, you can skip over the initial section that describes the
mysql.user
table, but
I think you'll find that reading it will help you better understand later sections, which
often discuss how SQL operations map onto underlying changes in that table.
Scripts shown in this chapter are located in the
routines
directory of the
recipes
dis‐
tribution.
Whether you use the MySQL 5.5, 5.6, or 5.7 release series, it is best to
use a recent version within the series. Changes to the authentication
system occur in early development versions that may produce re‐
sults that differ from the descriptions here.
