Last modified: 2026 July 24

---

Overview

You can create and manage the databases that control your websites’ and apps’ data in Meridian’s Databases hub. From here, you can create a database and its first user together, add more users to a database you already have, control what each user can do, and delete databases or users you do not need anymore.

• Meridian supports MySQL® and MariaDB® databases on every plan.
• PostgreSQL® is only available if your hosting plan and account allow it. If it is not available, the database type option will not appear, and you will only be able to create MySQL and MariaDB databases.

Creating a database

To create a database, perform the following steps:

1. Open the Databases hub and click Create Database.
2. If your account supports multiple database types, select a Database type option.
3. Enter a Database name value. Database names can only use printable ASCII characters, and cannot include quotes, backticks, slashes, backslashes, or a trailing space. The maximum length depends on the database type and version.
4. Enter a username and password for the database’s first user.
5. Set the database privileges for the new user.

When the wizard finishes, it displays your database’s connection details (host, port, and database name) along with the user’s password.

Creating a database user

If you need more than one user for a database, perform the following steps after creating the database:

1. In the Databases hub, click Manage next to the database.
2. Select the Users tab on the database’s detail view.
3. Click Add User.
4. Enter a username and password.
5. Set the database privileges for the new user.

After you save the user, their password will display.

Every database user can access exactly one database. If you need the same person or app to reach two databases, create a separate user for each one.

Managing user privileges

User privileges manage what a user can do with the database. For MySQL and MariaDB databases, you can configure individual privileges to customize access for each user.

Add privileges for MySQL and MariaDB

When you add privileges for a MySQL or MariaDB database, you can click All Privileges to grant every available privilege for the database, or click Read Only to only grant the SELECT privilege.

You can also select individual privileges from the table below:

Privilege	What It Allows
SELECT	Read data from tables.
INSERT	Add new rows to tables.
UPDATE	Modify existing rows in tables.
DELETE	Remove rows from tables.
CREATE	Create new tables and databases.
DROP	Delete tables and databases.
INDEX	Create and remove indexes on tables.
ALTER	Change a table’s structure.
CREATE TEMPORARY TABLES	Create temporary tables for the duration of a session.
LOCK TABLES	Lock tables to control concurrent access during an operation.
EXECUTE	Run stored procedures and functions.
CREATE VIEW	Create views (saved queries that act like virtual tables).
SHOW VIEW	View the definition of existing views.
CREATE ROUTINE	Create stored procedures and functions.
ALTER ROUTINE	Modify or remove stored procedures and functions.
EVENT	Create, modify, and remove scheduled database events.
TRIGGER	Create and remove triggers that run automatically on table events.

Add privileges for PostgreSQL

PostgreSQL does not support individual privileges. A user either has full access to the database or no access at all.

Remove privileges

To remove all of a user’s privileges on a database, click Revoke All Access. Revoking access deletes the user’s account automatically.

Deleting a database

To delete a database, perform the following steps:

1. Open the database’s detail view and go to the Advanced tab.
2. Click Delete Database in the Danger Zone section.
3. Confirm the deletion.

Deleting a database permanently removes the database and all of its data, but it does not delete the database’s users.

Deleting a user

To delete a single database user, perform the following steps:

1. Open the database’s Users tab.
2. From the user menu, select Delete.
3. Confirm the deletion.

Deleting a user permanently removes the account and revokes its database access.

To remove several users at once, select their checkboxes and use the bulk Delete action instead.