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