Databases - MariaDB / MySQL

MariaDB is a Database system that you can use to connect your Discord bot to a databasing system!

Did you join the SneakyHub discord server yet? If not, click here to join! Be sure that you also have a Discord bot already created. If not, refer to Create Server

==========================

SneakyHub has a built in MySQL and MariaDB support!

Create the Database

Go to the selected SneakyHub Panel Server, and click on the Databases tab. Here, we want to press New Database ( Figure 1A )

Figure 1A

Name you database anything ( Figure 1B ), but DO NOT PUT ANYTHING FOR CONNECTIONS FROM TAB. That will make it so your Discord Bot cannot access the database.

Figure 1B

After, you'll see that the database home has been updated. Press the icon, and you'll be revealed the database information ( Figure 1C )

Figure 1C

You've now created your database successfully.

Connecting to your Discord Bot ( Discord.js )

We're going to use the MySQL package to connect your Discord Bot to our database.

After, go into your bots code, and somewhere in your code enter this:

const mysql = require('mysql');

const db = mysql.createConnection({
  host: '10.10.10.103',
  user: 'your_username', // your database username, required
  password: 'your_password', // the database password that was generated, required
  database: 'your_database', // what you named your database, required
});

db.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL:', err);
  } else {
    console.log('Connected to MySQL database');
  }
});

Fill out the rest of the rest of the required fields. After, you can start your bot and it should successfully say, Connected to MySQL database.