Creating Databases

Go to Hosting Mode → Databases → New Database.

What to Fill In#

Database name — Enter a short identifier, e.g. shop or wordpress. The panel will prefix it with your account username automatically. If your account is alice and you enter shop, the actual database name in MariaDB will be alice_shop.

Database user — You can create a new user at the same time, or assign an existing user. If creating a new user, enter a username (again, it will be prefixed) and a password.

[!TIP] Use the password generator to get a strong password. Store it somewhere safe — the panel does not display it again after creation.

What Gets Created#

When you submit the form, Opterius:

1. Creates the database username_dbname in MariaDB.
2. Creates the MySQL user username_dbuser@localhost with the password you supplied.
3. Grants ALL PRIVILEGES on username_dbname.* to that user.

The database is immediately ready to use.

Connecting to the Database#

Use these credentials in your application's config file:

Host:     127.0.0.1  (or localhost)
Port:     3306
Database: username_dbname
User:     username_dbuser
Password: (the password you set)

For a WordPress wp-config.php:

define( 'DB_NAME',     'alice_shop' );
define( 'DB_USER',     'alice_dbuser' );
define( 'DB_PASSWORD', 'your-password' );
define( 'DB_HOST',     'localhost' );

[!NOTE] The database and user are only accessible from localhost by default. To allow connections from an external IP, see Remote MySQL Access.

Managing Existing Databases#

The database list at Hosting Mode → Databases shows all databases for your account, their size, and the users assigned to each. Click a database row to manage users, check privileges, or delete the database.