Database users: MySQL and PostgreSQL accounts

Database users: MySQL and PostgreSQL accounts

On top of the main access to a database, you can create additional users with their own name, password and privileges for your own databases. Both MySQL and PostgreSQL accounts are tied to one specific database on a given hosting – they are not shared across your whole account.

You will find them on the hosting's page, under the Services tab: the MySQL Accounts tile appears when the hosting has MySQL enabled, and the PostgreSQL Accounts tile appears when the hosting has at least one PostgreSQL database (see Databases: creating, credentials, import and backups).

Creating a MySQL account

1. On the MySQL Accounts page, click Add MySQL Account.
2. Select the database this user will access.
3. Enter a username (max 32 characters, letters, digits and underscores only) – the panel can suggest one via Use Suggested.
4. Enter a password (min. 8 characters) or generate one.
5. Fill in the Host field – % allows a connection from any host, or you can enter a specific IP address/hostname for restricted access.
6. Tick the privileges the account should have. The default privileges are SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER; others available include EXECUTE, TRIGGER, CREATE VIEW, CREATE ROUTINE and GRANT OPTION (the right to grant the account's own privileges to other users).
7. Enable Account lets the account connect immediately once created.

Creating a PostgreSQL account

The steps are the same, with two differences: the username can be up to 63 characters, and a smaller set of privileges is available – SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER (all but TRUNCATE are ticked by default). There is no Host field here – a PostgreSQL account is not tied to a specific host.

Connecting

Every MySQL account in the list has a Connection String action that shows both a URI and a DSN string, including the host (the database's internal name inside the hosting's network, typically mysql) and port 3306.

Editing, resetting the password and deleting

• Edit – changes the privileges, optionally the password, and the account's Enabled/Disabled state.
• Reset Password – sets a new password (min. 8 characters), either typed or generated.
• Delete – revokes the account's privileges and removes it permanently.

Limits

The panel has no plan-based limit on the number of additional MySQL or PostgreSQL accounts – only the number of databases they access is limited (see Databases). If you hit that limit, the fix is a hosting plan change.