How to grant access to a MySQL/MariaDB database to a database user

Introduction

A user must first be granted access to manage a MySQL/MariaDB database. This article discusses how to grant this access.

Procedure

1. Log into cPanel as the database owner's cPanel user.
2. Open the "Databases / Manage My Databases" feature.
3. Scroll down to the "Add User To Database" section.
4. Select the database user from the "User" dropdown menu.
5. Select the database from the "Database" dropdown menu.
6. Click the "Add" button.
7. Select the desired privileges.
8. Click the "Make Changes" button.

Additional resources

MySQL® Databases