← Guides

Managing your MySQL database with phpMyAdmin

After this guide you can log in to phpMyAdmin and view, edit, export and import your MySQL database.

With phpMyAdmin you manage your website's MySQL database from your browser. You can view and edit data, make a backup and restore a database.

What you need

  • Your domain name, for example yourdomain.com. It must already point to YourWWW.
  • A database. A new hosting package doesn't come with any databases. You create one yourself in the control panel.
  • Your MySQL username and password. We emailed them to you when your hosting package was created. You'll also find your username in the control panel.

Lost your MySQL password? Set a new one in the control panel. Does your website use this database? Then also update the password in your website's configuration file, or your website can no longer reach the database.

Logging in

  1. In your browser, go to https://<domeinnaam>/phpMyAdmin/. Replace <domeinnaam> with your domain name, for example https://yourdomain.com/phpMyAdmin/.
  2. Enter your MySQL username and password.
  3. Click Log in.
  4. On the left, click the name of your database. You now see the tables in your database.

Viewing and editing data

  1. On the left, click the table you want to view.
  2. Open the Browse tab. You now see the rows in the table.
  3. Want to change a row? Click Edit next to that row, change the data and click Go.
  4. Want to delete a row? Click Delete next to that row and confirm with OK.

Changes in phpMyAdmin take effect immediately and can't be undone. Always make a backup before you change anything.

Making a backup (export)

  1. On the left, click the name of your database.
  2. Open the Export tab.
  3. Under Export method, choose Quick.
  4. Under Format, choose SQL.
  5. Click Export. Your browser downloads a .sql file with your whole database.
  6. Keep this file in a safe place.

Restoring a database (import)

Use this to restore a backup, or to move a database from another hosting provider to YourWWW.

  1. Don't have a database yet? Create one first in the control panel.
  2. In phpMyAdmin, click the name of your database on the left.
  3. Open the Import tab.
  4. Click Choose file and select your .sql file.
  5. Leave the other settings as they are and click Import at the bottom.
  6. Wait until you see the message that the import was successful.

If the tables in your backup already exist in your database, the import may fail or overwrite existing data. So always make a backup of the current database first.

Running an SQL query

If you know SQL, you can also run your own queries.

  1. On the left, click the name of your database.
  2. Open the SQL tab.
  3. Type or paste your query in the text box, for example:
SELECT * FROM tablename LIMIT 10;
  1. Click Go.

Troubleshooting

  • The phpMyAdmin page doesn't open. Check that you typed the address correctly, including capital letters: /phpMyAdmin/. If your domain name doesn't point to YourWWW yet, this address won't work.
  • You get a message that login failed. Check your username in the control panel and watch out for capital letters and spaces at the start or end of your password. Still not working? Set a new password in the control panel.
  • You don't see a database on the left. A new hosting package doesn't come with any databases. Create one in the control panel and log in to phpMyAdmin again.
  • The import fails. Check that you chose a .sql file and that the tables don't already exist in your database.

Still stuck? Go to create a ticket and we'll help you out.

Updated on 18 November 2026.

Was this guide helpful?

Still stuck?

Create a ticket or send us an e-mail.

Are you sure?