Database Reference
In-Depth Information
MariaDB User Account
Management
The root user in our MariaDB database has rights to every database and table, we
don't want to use it for day-to-day operations or hand out the login ID and password
of root 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.
User privileges
The privileges or rights that we can grant to users are many and varied. They break
down into three main categories:
• Global administrative privileges
• Database, table, and column privileges
• Miscellaneous privileges
