Scarlett
Scarlett Database
Create the database, import install.sql, configure utf8mb4, and verify the connection.
Create and import#
Your database provider supplies five separate values: hostname, port, database name, username, and password. The database host is not your website URL. If remote access is restricted, allow the bot host's outbound IP in the provider firewall or access list.
- Create a MySQL or MariaDB database.
- Create a dedicated database username and password and grant it access.
- Find the database hostname in the provider panel.
- Open phpMyAdmin, select the database, and import
install.sql. - Enter the credentials in Scarlett’s SQL configuration and restart.
SQL settings#
| Setting | What to enter | What it controls |
|---|---|---|
charset | utf8mb4 | Full Unicode storage, including Discord names and symbols. Leave unchanged unless you understand the consequences. |
host | YOUR_DATABASE_HOST | Database network hostname. |
user | YOUR_DATABASE_USER | Dedicated database login. |
password | YOUR_DATABASE_PASSWORD | Private database password. |
database | YOUR_DATABASE_NAME | Database containing the imported tables. |
Verify the connection#
Expected console message
Connected to the database successfullyIf it fails, compare each value separately and confirm remote access or firewall rules permit the bot host.