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
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
- Check the names and the server
- Create the user and the database
- 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).