Frequently asked questions

Keyword:

How do I manage my MySQL database?

There are several things you can do to administer your database with us, depending on what you want to do.

Activate databases
Change password
Backup/download database
Drop/delete/erase databases
Restore databases from backup
Administration from your own computer
Administration with the mysql command in Unix shell
Administration with phpMyAdmin
TLS connections (SSL)

Please note that you do not have administrator/system privileges for our MySQL servers. Certain things are therefore restricted. If the MySQL documentation shows that your action requires system privileges, you do not have access. For instance, you may not choose the name(s) for your database(s), or create additional users with access to your database(s).

Change password

When you have activated a MySQL database, you may also change its password. Follow the same steps as when activating your database. Your password is ordinarily updated in the database within 10-20 minutes.

Restore databases from backup

To restore a database from backup, use the same program you used to backup with. There may be significant differences between how different software handles backup.

Exception: if you backup with mysqldump, you cannot use it to restore. You may use other software, e.g. by running the backup file as a regular SQL script.

Drop/delete/erase databases

Note! This is a risky procedure! Backup your database first!

Via the control panel

Login as usual in the controlpanel at www.domainnameshop.com/login.
Select the domain from My domains.
Select the Web hosting tab.
Select View/change on the MySQL line.
Click "..." on the rightmost on the line with the relevant database, then Erase.

With a database administration tool

Using your favorite database administration tool, you may use the command

drop database DATABASENAME;

which will remove your entire database. If you do not disconnect and immediately perform

create database DATABASENAME;

the database will be recreated as empty. As a last resort, you may also change your database password , this will recreate any missing database.

Note! Our control panel for databases cannot discover changes you perform via other programs for database administration. If you e.g. drop database without recreating the database yourself, our control panel will still believe that the database exists, and show you its information. But if you change your password via the control panel, the database will be recreated within 10-20 minutes.

Administration from your own computer

There is a lot of database administration software that you can install on your own computer, here are some of them:

DBeaver (MacOS, Windows, Linux)
Sequel Pro (MacOS)
EMS SQL Manager (Windows)
NaviCat (MacOS, Windows, Linux)
HeidiSQL (Windows)

Administration with the `mysql` command in Unix shell

This is for advanced users only.

The mysql command is available on our login server for Unix shell, login.domeneshop.no, enabling you to manage the database.

Administration with phpMyAdmin

We have installed phpMyAdmin.

We DO NOT recommend that you install phpMyAdmin, neither as a plugin to Joomla or WordPress, nor as a separate program. Use software on your own computer instead.

If you still want to install phpMyAdmin, ensure that you download it from phpMyAdmin, and that you join the phpMyAdmin news mailing list so that you update phpMyAdmin immediately when a new version is available.

TLS connections (SSL)

As of late July 2018, we offer TLS connections to MariaDB 10.x databases, and from December 2018 to MySQL 5.7 databases. External connections must go via TLS. There are also additional limits on the number of external connections.