MySQL 8.0 is continuing in the same vein as that set by MySQL 5.7—to be secure by default. The Oracle MySQL development team has added a number of interesting security features, including, SQL roles, making the ACL statements atomic, and also dynamic global privileges.
Another aspect that has been improved is the keyring API.
New MySQL 8.0 roles will give you better access controls:
- An easy way to manage user and application rights
- As compliant with standards as is feasible in practice
- Multiple default roles
MySQL 8.0 provides a better way to have administrative-level access controls with dynamic privileges:
- Too often, super privileges are given for tasks when fewer privileges are actually required.
- These are needed to allow the addition of administrative access controls.
Examples of the new components include the following:
- Replication ...