MariaDB: Creating a database, then authorising a user

From within cPanel, you can create MariaDB databases and assign users to them (via ACLs).

Once you're logged into cPanel, head to "MariaDB/MySQL databases" to view a list of current databases.

From there, you can click to Add a New Database, and choose a name for the database to be given.
Note that we enforce cPanel username based database naming - they'll use cpaneluser_dbname

Without a user though, you're not going to be able to configure any app or system to talk to it!
At the bottom of the MariaDB/MySQL Databases page, you're able to create a new MariaDB user.

Choose a relevant username which will be appended to the cPanel user (ie. cpaneluser_dbuser)
Make sure that the password is secure, and note it down as you'll need it to configure your app.

With your MariaDB database AND user now ready to go, you can assign the user to the database.

On the same page, there's a section with 2 drop-down boxes to assign - choose your DB and user.
Click through to assign permissions between the two, noting that you'll usually want all of them.

You can now link your newly-created database and user up to your web system!

Please let our team know if you have any problems getting them to talk and we'll gladly help.

(Hint: Installatron handles this for you, and installs many common web apps - find it in cPanel!)

  • 28 users found this helpful
Was this answer helpful?

Similar, and hopefully helpful

Greylisting: What it is, how we use it & how to switch it off

Greylisting provides an additional layer of inbound email security by delaying potentially...

Files: Uploading and downloading using an FTP client

In addition to cPanel's File Manager (web-based), you can use FTP to manage files & folders....

Auto-reply: Creating an Auto-responder for your Mailbox

cPanel makes it easy for you to quickly add Auto-responders/Out-of-office to your Email Accounts....

Configuring your Mailbox: Windows / macOS & Android / iOS

Getting your email working well doesn't take long, though it deserves a few moments to get it...

Email: Creating a new Email Account / Mailbox easily

After logging in directly or through my.Merlot, via cPanel you can create new Mailboxes with...