A MySQL database can be used to quickly store and manipulate large amounts of data or content. A database is required when using a CMS such as Wordpress or Joomla. Databases can be created in your control panel, and can be managed through PHPMyAdmin.
Creating a database
- Log on to your control panel and click on the tab 'Domain & Hosting'.
- On the left hand side, click on your domain name (do not check the box).
- Click on 'Manage your website'.
- Click on 'Databases'.
- Click on 'Create Database' and follow the instructions here. For a new database, 100 MB is more than enough to start with.
After creating a database, the username and password to log on to the database will be e-mailed to you. Make sure you save this e-mail. The e-mail address used for this can be found in your control panel. From here, click on your user name in the top right corner and click 'My Account'. The e-mail address which we use to send you the information can be found on this page.
If you have lost your password, you can change the password in your control panel. In here, go back to the 'Databases' page and click on the database name. Here you will be able to change the current database password. Don't forget to hit 'Save' after changing the password.
After changing the database password, do not forget to change the password in the configuration file of your website as well. This is usually the wp-config.php file(for WordPress) or the config.php file.
In this file, look for the line below. Change the old password next to DB_PASSWORD to the new database password.
/** MySQL database password */ define('DB_PASSWORD', 'wachtwoord_oud');
Logging on to your database
You can log in to PHPMyAdmin via mysql.transip.eu. Use the following info:
- Server: Your domain name (not localhost).
- Username: The username for the database.
- Password: Your database password.
This information is also e-mailed to you after creating the database, but can also be found in your control panel by going to the 'Databases' page as mentioned before.
To quickly log on to your database, click on the username at the 'Databases' page. You will find that the required information is already filled in for you. All you need to enter now is your database password.
Please note that the database cannot be accessed from outside the webhostingpackage itself by an external server for example, you can only access it via PHPMyAdmin.
If you are using the 1 Click WordPress Install option for your webhosting package, you will not need to create a database. The database will be created and filled in automatically if there is a slot for a database available.
When using a different type of CMS, you may need to create and fill in a database yourself. We recommend you research how to manage a database, as the smallest changes to your database can have great consequences for your website.