What is MariaDB?

MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation in 2009.

Creating the server

To create a server, we suppose that you've already created and linked an account into the panel.

In that case, go to DBH server and run this command:

For a free server:

DBH!server create mariadb [optional server name]

Click Here to Access Your Server

Created

126

mariadb

Untitled Server (settings -> server name)

Command Executed By: jonfirexbox (856176853719187506)

For a donator server:

DBH!server create-donator mariadb [optional server name]

Click Here to Access Your Server

Created

126

mariadb

Untitled Server (settings -> server name)

(1 slot / 6 slots)

Command Executed By: jonfirexbox (856176853719187506)

Connect to the database

In order to connect to your fresh created database start the server and use the following link:

jdbc:mariadb://localhost:3306/DB?user=root&password=myPassword

Fields

The link given above isn't enough for you to connect to the database, now you have to modify it to actually connect to the database.

Node

"nX" in "nX.danbot.host" is replaced with your server's node. It can be:

Free Node	Domain
PNode 1	pnode1.danbot.host
PNode 2	pnode2.danbot.host
PNode 3	pnode3.danbot.host

Donator Node	Domain
Dono 01	dono-01.danbot.host
Dono 03	dono-03.danbot.host

Create DB

First you will need to run:

CREATE DATABASE dbhDB;

in your servers console.

Create user and password

Then we will run this next command:

CREATE USER "DBHMariaDB"@"your_allowed_ipaddr" IDENTIFIED BY "Dbh!sTheBest!@";

Grand all privileges

This is a very import step as this allows you to access the DB:

GRANT ALL PRIVILEGES ON dbhDB.* TO "DBHMariaDB"@"88.99.138.239";

And last thing you need to run is:

FLUSH PRIVILEGES;

Port

"port" is your server's port that can be found in the main page.

Final result

As soon as you finished with the link it should look like this:

jdbc:mariadb://pnode1.danbot.host:3306/DB?user=DBHMariaDB&password=Dbh!sTheBest!@

Conclusion

Now you can deal with MySQL database. To find out more about MariaDB visit their documentation website!