MySQL databases

This section displays your current databases and the users assigned to each one. Below this are the options which control everything to do with your MySQL databases:

Creating a New Database

Simply enter the name of the database you wish to create and click the Add DB button. The DB name will be prefixed with your account username and an underscore so the full DB name will be username_dbname

Creating a User

Simply enter a username and password and click the Add User button. The username will be prefixed with your account username and an underscore so the full DB username will be username_dbusername

You can create one user which you can add to all your databases or create a different user for each database which adds to security.

Add a User to a Database

You must create a user and add them to a database before that database can be used by, for example, a PHP script.

Select the user from the first drop-down box and select the database from the second drop-down menu and click the Add User to Db button.

Access Hosts

If you wish a website on another domain to be able to access and use one of your databases, you can add the domain to allow access to in this section.

Simply enter the domain name (without the www.) and click the Add Host button.

phpMyAdmin

You can use phpMyAdmin to administrate your MySQL databases in a web based environment.