An Overview of Security Features in MySQL 5.7
summary
MySQL 5.7 adds concrete controls: password expiration per-user and pluggable authentication with ALTER USER to switch plugins; SQL roles with optional auto-activation; a connection-control plugin that adds incremental delays after configurable failed attempts to blunt brute-force attacks; InnoDB tablespace encryption using a keyring backend, 256-bit master keys and daily key-rotation, with no significant measured performance hit; expanded SSL mode options (disabled/preferred/required/verify_identity), automatic server TLS cert generation, random expired root password on install, and secure_file_priv restrictions.
AI-written summary · about
chapters (6)
- 0:00Introduction to MySQL 5.7 security
- 1:49User management features
- 3:56Activity control enhancements
- 4:58Encryption and communication security
- 9:00Secure by default installation
- 12:02Q&A on security features
