Skip to main content
Most website software, including WordPress, stores its content in a database. In the Databases tab you create databases and the users that are allowed to use them, open phpMyAdmin, and import or export your data.

Difficulty

Intermediate

Time

5 minutes
Installing WordPress or another app from Apps creates its database and user for you. You only need this page for software you install yourself.

​
The Databases tab

Go to Websites, click your website, then click Databases. There are two lists: Databases and Users.
Databases tab with Databases and Users sub-tabs, Add user and Add database buttons, and a list of databases with type, users, size, a phpMyAdmin icon and a menu

Your databases

Every database and username starts with a prefix based on your website, such as example_com1_. The panel adds it for you.

​
Create a database

1

Click Add database

The form shows how many databases you’ve used, for example 1 of ∞ databases used.
2

Name the database

Type a short name such as shop. The full name becomes something like example_com1_shop.
3

Choose a user

Tick an existing user, or choose Create new user and enter a Username and Password (lowercase, uppercase, number, special character, at least 10 characters; the key icon generates one).
4

Check the privileges

Under Advanced, All database privileges is ticked. Leave it on for normal website software.
Add database form with the database name prefix, a list to tick an existing user or create a new user with username and password, and an Advanced section with All database privileges ticked

Add a database

5

Click Add

You’ll see ‘shop’ added. Write down the full database name, username and password.

​
Connect your website to the database

Most software asks for four details: To see these details again, click ⋮ → Manage next to the database.
Database page with Connection info (Unix socket path and a note to use localhost for PHP, TCP connection hidden), a PhpMyAdmin button, and a Users list with Add database user

Managing a database

​
Use phpMyAdmin

phpMyAdmin lets you browse tables, run queries and edit rows. Open it from the phpMyAdmin icon in the database list, the PhpMyAdmin button on the database page, or phpMyAdmin in Quick links on your website’s home page.
Changes in phpMyAdmin take effect immediately and can’t be undone. Export the database first.

​
Import and export a database

1

Open the database

Click ⋮ → Manage next to it.
2

To import

In Import SQL file, upload your .sql, .gz or .zip file (500 MB maximum). Import into an empty database to avoid clashes with existing tables.
3

To export

In Export SQL file, click Download to save a .sql.gz copy to your computer.

​
Manage a database user

Open the Users list and click a user, or click their name on a database’s page.
Database user page with username, password Reset button, authentication plugin mysql_native_password, a Remote access IP field with Add, the hosts defined list, a Database access table and a Delete button

A database user

  • Password: click Reset to set a new one, then update your website’s configuration file with it.
  • Database access: the databases this user can use.
  • Delete: removes the user. Websites using it will stop working.

​
Allow remote access

By default, databases only accept connections from your website. To connect from your own computer (for example with MySQL Workbench or DBeaver):
1

Find your public IP address

Search “what is my IP” in your browser.
2

Add it to the user

On the user’s page, enter it in Remote access IP and click Add. You’ll see a message such as ‘203.0.113.10’ added.
3

Connect

Use the TCP connection address from the database’s Connection info, port 3306, and the user’s name and password.
Port 3306 is open to the internet, but only the IP addresses you add here can sign in. If your home or office IP changes, add the new one. If it still doesn’t connect, open a ticket.
Remove IPs you no longer use with the bin icon in the hosts list.

​
Troubleshooting

One of the four details in your website’s configuration file is wrong. Check the full database name and username (with the prefix), reset the password if needed, and use localhost as the host.
The user isn’t attached to that database, or the password is wrong. Add the user on the database’s page with Add database user, or reset the password.
The file must be .sql, .gz or .zip and no larger than 500 MB. For bigger databases, split the file or open a ticket.
Restore it from a backup with Custom restore. See Create and restore backups.

​
Need Extra Help?

If you encounter any issues, our support team is ready to assist:

​
Save on Your Hosting

Ready to upgrade your hosting? Use code KB20 at checkout for 20% off your first order!
Last Updated: October 2026