Advanced MySQL 8

Summary

In this chapter, we covered the new MySQL 8.0 security features, including MySQL roles. This is a new security and administrative feature that allows DBAs to simplify user management and increases the security of their multi-user environments. You also learned about the access privileges system and security plugins. Finally, you learned about the security impact this has on the database server and all the other applications.

We introduced the new security features in MySQL 8.0, the privileges provided by MySQL 8.0, and also explored the differences between dynamic and static privileges. Finally, we looked briefly at the grant table, covered how to troubleshoot a connection problem, and shared some tips and techniques.