Database Management
This section of the Control Panel will let you manage your MySQL and/or PostgreSQL databases.
Database management is split into two parts. First you will use the Control Panel to create the database itself and the database accounts that will be allowed to access the database. Then you can use either phpMyAdmin or phpPgAdmin (depending of the type of database) to browse the databases/schemas you created with the Control Panel and to add or drop tables or views, execute arbitary SQL statements and perform various other administrative tasks on your tables and data.
Managing MySQL Databases and Users
Click the "MySQL" link in the "Database" group in the Control Panel home screen. By default there aren't any created databases in your hosting package so your screen should then look like this:
Your database name and database username are always prefixed with the UNIX username associated with your hosting package in order to ensure that your database names and usernames are unique throughout the system. You should enter the database name in the "Database:" field of the "Create New Database" form. In this example the user has entered mydb as the database name so the complete database name will be mydomain_mydb. Enter a username the same way and a password for that username.
Click "ADD" and the database will be created and you will get to the main MySQL management screen:
The screen is divided into two parts: "Database Information" that lets you manipulate your databases and "Database Usernames Information" which lets you manage your database accounts.
Databases
The databases section of the "MySQL Database" screen displays a list of all databases that exist in your hosting package. For each database you can see which of the existing database users in your package is allowed to access it and which are not - there is a checkbox in front of each username indicating whether that user can use the database or not. To change the permissions for a database check/uncheck the respective usernames and click the "Update" icon in the "Manage" column of the table. Remember that there must be always at least one user with access to the database.
To remove (or drop) a database click the "Remove" icon in the "Manage" column.
 | This means that all data contained in the respective database will be lost. Use this function with caution. If you remove an important database by mistake you can restore it from a Custom Backup. If you haven't made a custom backup of that database please contact our support service. We make automated backups of all databases at regular intervals. |
Database Accounts
You can manage your database accounts in a similar way. You have a list of all usernames and the database they are allowed to access in the "Database Usernames Information" table. To give permissions of a user to access a database check the respective checkbox and click the "Update" icon in the "Manage" column of the table. To take away the user's permissions on a database simply uncheck the respective database and again click the "Update" icon. To drop the user use the "Remove" icon.
To add a new user enter a new username and password in the "Create New Database User" form, check the databases that the user should be able to access (you have to select at least one database) and click the "ADD" button.
At the bottom of the screen there is a link to the phpMyAdmin tool that you can use to manipulate the databases in your hosting package.
Using phpMyAdmin
phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. It is a third-party tool which we have integrated into our system. It can create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges and export data into various formats.
To access phpMyAdmin click the "phpMyAdmin" link on the main screen of your Control Panel or the phpMyAdmin logo in the "MySQL Database" screen. Your browser should prompt you for a username and password. Input one of your database accounts (you should already have created one).
Once you log into phpMyAdmin you should see a drop-down list of all databases that the database account you're using has access to. Select a database from that list.
 | If you see a "test" database in the list please do not use it! |
For more information on phpMyAdmin please refer to the official documentation available at their site.
Managing PostgreSQL Databases and Users
Click the "PostgreSQL" link in the "Database" group in the Control Panel home screen. By default there aren't any existing databases in your hosting package so your screen should then look like this:
Your database name and database username are always prefixed with the UNIX username associated with your hosting package in order to ensure that your database names and usernames are unique throughout the system. You should enter the database name in the "Database:" field of the "Initialize a New PostgreSQL Database" form. In this example the user has entered production as the database name so the complete database name will be mydomain_production. Enter a username the same way and a password for that username. Note that this user will own your database and will always have access to all schemas you create.
Click "ADD" and the database will be created and you will get to the main PostgreSQL management screen. A default "public" schema will be created. No other users on the server will have access to this schema despite the fact that it's named "public".
The screen is divided into two parts: "Schema Information" that lets you manipulate your schemas and "Database Usernames Information" which lets you manage your database accounts.
Schemas
The schemas section of the "PostgreSQL Database" screen displays a list of all schemas that exist in your database. For each schema you can see which of the existing database users in your package are allowed to access it and which are not - there is a checkbox in front of each username indicating whether that user can use the schema or not. To change the permissions for a schema check/uncheck the respective usernames and click the "Update" icon in the "Manage" column of the table. Remember that the database owner (the user you entered when you initialized the database in the previous step) always has access to all your schemas.
To remove (or drop) a schema click the "Remove" icon in the "Manage" column.
| This means that all data contained in the respective schema will be lost. Use this function with caution. If you remove an important schema by mistake you can restore it from a Custom Backup. If you haven't made a custom backup of that database please contact our support service. We make automated backups of all databases at regular intervals. |
Database Users
You can manage your database accounts in a similar way. You have a list of all usernames and the schemas they are allowed to access in the "Database Usernames Information" table. To give permissions of a user to access a schema check the respective checkbox and click the "Update" icon in the "Manage" column of the table. To take away the user's permissions on a schema simply uncheck the respective database and again click the "Update" icon. To drop the user use the "Remove" icon.
To add a new user enter a new username and password in the "Create New Database User" form, check the databases that the user should be able to access (you have to select at least one database) and click the "ADD" button.
At the bottom of the screen there is a link to the phpPgAdmin tool that you can use to manipulate the data in your schemas.
Using phpPgAdmin
phpPgAdmin is a web-based administration tool for PostgreSQL. It is a third-party tool which we have integrated into our system. It can create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields and manage privileges.
To access phpPgAdmin click the "phpPgAdmin" link on the main screen of your Control Panel or the phpPgAdmin logo in the "PostgreSQL Database" screen. You should see phpPgAdmin's login screen prompting you to enter an username and password. Input one of your database accounts (you should already have created one).
Once you log into phpPgAdmin you should see a drop-down list of all schemas in your database but the user you're using may not be authorized to access all of them (depending on the configuration you set up in the PostgreSQL Database screen).
For more information on phpPgAdmin please refer to the FAQ or How To Get Help resources available at their site.