Chapter 4. Administering MariaDB
The root user in our MariaDB database server will have rights to every database and table. We don't want to use the MariaDB root user for day-to-day operations or hand out the password to anyone who doesn't absolutely need to have it. Instead, we want to create users that have specific rights to the specific databases they need to work with.
In this chapter, we will cover the following topics:
- User privileges
- Creating users
- Granting, revoking, and showing permissions
- Setting and changing passwords
- Removing users
