The MySQL Workshop

Chapter 14: Manipulating User Permissions

This chapter deals with creating, modifying, and dropping user accounts in MySQL. First, we will begin with creating users, and then we will move on to setting and changing their passwords and other properties. This will be followed by granting and revoking permissions. Additionally, we will troubleshoot any connection issues that might arise when users try to connect to the database. By the end of this chapter, you will be able to use roles to grant and manage the permissions for different groups of people.

In this chapter, we will cover the following main topics:

• Introduction to user permissions
• Exploring user and accounts
• Exercise 14.01 – creating users and granting permissions
• Changing users
• Flush ...