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!)

  • 0 users found this helpful
Was this answer helpful?

Similar, and hopefully helpful

Email: Restricting flow and login rights for mailboxes

From within cPanel, you're able to restrict mail flow each way, and disable login rights...

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....

Email: Creating a new email account / mailbox easily

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

Moving host: Packaging everything to move in or out

Provided a host hasn't disabled it, cPanel makes it easy to download a FULL back-up. Other...

Installatron: Adding a new WordPress install to your site

While we include Installatron & Softaculous, we actively recommend using Installatron's...