Skip to content
Shellbay

Databases · about 1 min · 3 steps

Create a MariaDB database

Creates a new MariaDB database and a user that can only use it from this server, with a random password saved in a file only root can read.

Runs on

  • Debian / Ubuntu: supported
  • RHEL / Fedora: supported
  • Alpine: supported

Before you start

  • Run the MariaDB (secured) workflow first.

What it changes on your server

  • Creates the database (utf8mb4) and gives the user full rights on it, and nothing else.
  • Creates the user, limited to connections from this server (localhost), with a random password saved in /root/shellbay-mariadb-<database>.txt (root only). An existing user keeps its password.

What Shellbay asks you

  1. Name the database and its user

    Use lowercase letters, digits and _, starting with a letter. Apps such as WordPress usually get their own database and user. If the user already exists it gets access to the new database and keeps its password.

    Database name
    Text, up to 63 characters
    User name
    Text, up to 63 characters

    Example: wordpress

Steps

  1. Check the names and the server
  2. Create the user and the database
  3. Check the database and user

Shellbay checks the server before the first step, and stops at the first step that fails.

When it's done

  • The database ‹database name› is ready for ‹user name›@localhost.
  • If Shellbay created the user, its password is on the server: run sudo cat /root/shellbay-mariadb-‹database name›.txt and copy it into your app's settings (database host: localhost).