SiteHost

Managing Databases

Create a Database

  • Once you are logged into the Control Panel click Databases in the left menu.
  • Click on the server that you want to create the database.
  • Click on Add Database in menu or the plus icon on the top right of the grid.
  • Enter the name of the database you wish to create, then click the Add Database.
  • You will be asked to assign a user to the database you just created. If you have previously set up users on this database server, select the name of the user you wish to add to the database from the drop-down list. If the list is empty, you will need to create a user which can be done by clicking the Create button and then following the instructions for creating a new database user.
  • For Host, type in the location of the MySQL database server. If you're unsure of what to type, leave it as 'localhost'.
  • Select the privileges you wish to grant to the user on the given database. An explanation of the privileges available and their effects is available on the MySQL website.
  • Click the Add User to Database button to confirm and apply.

You will be asked for another name if a database of the same name already exists.

Managing a Database (PHPMyAdmin)

phpMyAdmin is a free software tool intended to handle the administration of MySQL via a browser. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while users also have the ability to directly execute any SQL statement. phpMyAdmin also makes it easy to backup and restore databases.

  1. Once you are logged into the Control Panel click Databases in the left menu.
  2. Click the server which has the database you want to access.
  3. Click the More Actions icon (᛫᛫᛫) and click Database Admin.
  4. You will be prompted for a username and password for a valid user that has been added to the database.
  5. Click OK and phpMyAdmin will load. For instructions on how to use phpMyAdmin see the official documentation.

Deleting a Database

  1. Once you are logged into the Control Panel click Databases in the left menu.
  2. Click the server which has the database you want to access.
  3. On the right of the database you want to remove click the More Actions icon (᛫᛫᛫) and click Delete.