How to create a MySQL database and database user

For hosting customers · Updated 2026-10-29

On this page
  1. Steps
  2. The details for your website
  3. Good to know
  4. Common questions

Most websites (WordPress, shops, forums) store their content in a MySQL database. You need three things: a database, a database user with a password, and the user added to the database. The server runs MariaDB, which is compatible with MySQL.

Steps

  1. Log in to the control panel (https://<server>:2083).
  2. Open MySQL Databases in the menu (section Databases).
  3. Under Create database, enter a name, for example shop, and click Create. Your username is added in front: the database is called username_shop.
  4. Under Create database user, enter a name, for example shop, and a password, or click Generate. Click Create. The user is called username_shop. Copy the password now.
  5. Under Add user to database, choose the User and the Database and click Grant all privileges.

The database appears under Databases with the user under Privileged users.

The details for your website

SettingValue
Database nameusername_shop (the full name, with the prefix)
Usernameusername_shop
Passwordthe password from step 4
Hostlocalhost

See database connection details for examples in PHP and other languages.

Good to know

  • Names: lowercase letters, digits and _, up to 32 characters after the prefix. The names pma and pgtool are reserved.
  • Passwords: at least 8 characters, with three of: lowercase letters, uppercase letters, digits, symbols.
  • New databases use the utf8mb4 character set (utf8mb4_unicode_ci), which supports every language and emoji.
  • Your plan sets how many databases you can have. The top of the page shows how many are used; MySQL and PostgreSQL databases count together.
  • One user can be added to several databases, and one database can have several users.
  • Installing WordPress or an application from the panel creates its own database and user automatically.
  • Delete next to a database removes it with all its data. There is no undo; keep a backup.

Common questions

Why does my site say "Access denied for user"?

The user is not added to the database, the password is wrong, or the name is missing its prefix. See fixing database connection errors.

Can I create a database from phpMyAdmin?

No. Create databases here in MySQL Databases; they then appear in phpMyAdmin.

Can I rename a database?

No. Create a new database, copy the data into it (export and import), and delete the old one.

Was this article helpful?

Still stuck?

Ask the AI about your exact situation — it answers from this knowledge base — or contact us.