User's Guide - 9 - Hosting Databases

9 Hosting databases
9.1 Hosting MySQL Databases
9.1.1 Creating MySQL Database and Its Users
9.1.2 Editing MySQL databases (phpMyAdmin)
9.1.3 Changing MySQL disk quota
9.1.4 Changing user passwords
9.1.5 Adding MySQL users and granting them privileges.
9.2 Hosting PostgreSQL Databases
9.2.1 Creating PostgreSQL User(s)
9.2.2 Deleting Users and changing their passwords
9.2.3 Creating PostgreSQL Databases
9.2.4 Editing PgSQL Databases and User Privileges
9.2.5 Changing PgSQL disk quota
9.3 Hosting Microsoft SQL Databases
9.3.1 Creating Microsoft SQL Logins
9.3.2 Creating MS SQL Databases
9.3.3 Adding New MS SQL Database users
9.3.4 Changing MS SQL Database quota
9.4 Creating ODBC DSN Records
9.4.1 Creating a new DSN Record
9.4.2 Editing DSN Records
9.4.3 Deleting DSN Records

Hosting databases

9.1 Hosting MySQL Databases

MySQL is a database management system. It allows you to add, access, and process stored data. The SQL part of MySQL stands for "Structured Query Language" - the most common standardized language used to access databases.

9.1.1 Creating MySQL Logins

MySQL users cannot exist separately from MySQL databases. You must stick to the following sequence:

Create a database
Add MySQL users to each created database.
However, MySQL users can be shared by different databases.
To create a MySQL database, do the following:
Click MySQL Server on your control panel home page.
Click Add database at the bottom of the form:
On the form that shows enter the name of the database and database description if needed:

Agree with additional charges if any.
In the form that appears, create a new user or grant privileges to users of other databases:

Add a new user to the database you have just created. User roles are explained below. Click Add user.
Choose roles for users of other databases so they can use your new database. Click Grant.

Click Finish to complete creating your MySQL database.

9.1.2 Editing MySQL databases (phpMyAdmin)

You can edit the content of your databases using the phpMyAdmin utility that comes with your control panel.

To run phpMyAdmin, do the following:

Click MySQL Server on your control panel home page.
In the form that appears, click the name of the existing MySQL Database you want to edit or the Edit icon on its right:

In the form that appears, click Built in phpMyAdmin control panel to start editing your database:

Follow the instructions of the phpMyAdmin control panel to edit your MySQL DB.

9.1.3 Changing MySQL disk quota

MySQL disk quota is the maximum allowed size of one MySQL database. If you exceed this quota, you'll be charged for overlimit at a different (usually higher) price.

To change MySQL disk quota, do the following:

Click MySQL Server on your control panel home page.
Click the MySQL Database or the Edit icon on its right:
Click the Change button against the Quota field:

Enter the new quota.
Click Submit.
Agree to additional charges.

9.1.4 Changing user passwords

To change user password in the MySQL database, do the following:

Click the MySQL Database.
In the form that appears (see above), click the Change password icon next to the DB user.

9.1.5 Adding MySQL users and granting them privileges.

Here you will learn how to add new users to an existing MySQL database.

Click MySQL Server on your control panel home page.
Click the MySQL Database or the Edit icon on its right:
On the form that shows, click the Add icon against the Database users field.
Fill the following form:

Each user role involves a fixed set of privileges on this specific database:

Role: Set of privileges:

read select

read/write select, insert, delete, update

dba select, insert, update, drop, create, alter, index

Click the Add or Grant button and agree to additional charges.
To edit privileges, click the Edit icon next to the user. You will be brought to the Privilege Maintenance page.

Check or uncheck the desired privileges and press the Submit button.

Note:For more information on MySQL access privileges, please refer to www.mysql.com.

IMPORTANT: any changes in user privileges will be applied to the whole selected database.

9.2 Hosting PostgreSQL Databases

PostgreSQL is a database management system based on Unix platform. It allows you to add, access, and process stored data. The SQL part of PostgreSQL stands for "Structured Query Language" - the most common standardized language used to access databases.

9.2.1 Creating PostgreSQL User(s)

Unlike with other databases, a PostgreSQL database cannot be created without a user.
You must stick to the following sequence:

Create a PostgreSQL user.
Create a database.

Note: The first user in the list of users is the owner of a database, however the database can be used by others who obtain permissions from the owner.

To create a PostgreSQL database user, do the following:

Click the PostgreSQL Server icon on your control panel home page.
At the bottom of the page that shows, click the Add user icon to start creating a new user.

Fill the Add PostgreSQL user form on the PostgreSQL Users page.

Agree to additional charges.

9.2.2 Deleting Users and changing their passwords

To delete the PgSQL database user, do the following:

Click the PostgreSQL Server icon on your control panel home page.
Click the Trash icon next to the user name on the PostgreSQL user management page.
Agree to additional charges.

Important: Trash icon appears only next to non-owners. The owner of a database cannot be deleted, unless you remove the PostgreSQL database.

To change the user password, do the following:

Click the PostgreSQL Server icon on your control panel home page.
Click the Change icon next to the name of the user.
Enter a new password, confirm it, and click Change.

Important: the user privileges can be changed by means of phpPgAdmin.

9.2.3 Creating PostgreSQL Databases

Having at least one user, you can create a PostgreSQL database. This user will become the owner of this database.

To create a database, do the following:

Click the PostgreSQL Server icon on your control panel home page.
Click Add Database in the PostgreSQL Databases section:

Enter the name and description of the database:

Click Submit and agree to additional charges.

9.2.4 Editing PgSQL Databases and User Privileges

You can edit the content of your databases and user privileges using the phpPgAdmin utility that comes with your control panel.

To run phpPgAdmin, do the following:

Click the phpPgAdmin icon on the control panel home page.
Click the name of the database you would like to edit.

You can also start this utility from the PGSQL database management page:

Click the PostgreSQL Server icon on your control panel home page.
Click the Edit icon for the database you are going to edit:

In the form that appears, click Built in phpPgAdmin control panel to start editing your database:

Follow the instructions of the phpPgAdmin control panel to edit your PgSQL DB

9.2.5 Changing PgSQL disk quota

PgSQL disk quota is the maximum allowed size of one PgSQL database. If you exceed this quota, you'll be charged for overlimit at a different (usually higher) price.

To change PgSQL disk quota, do the following:

Click the PostgreSQL Server icon on your control panel home page.
Click PGSQL Database.
Click the Change icon in the Quota field:

Enter the new quota.
Click Submit.
Agree to additional charges.

9.3 Hosting Microsoft SQL Databases

Microsoft SQL database is a database management system based on Windows platform. It allows you to add, access, and process stored data.

9.3.1 Creating Microsoft SQL Logins

Unlike other SQL databases, you need a login to start working with MS SQL databases. So, you must stick to the following sequence:

Create a login to connect to the Microsoft SQL server.
Create databases
Create users to work with Microsoft SQL databases.
To create a MS SQL login, do the following:
Click MS SQL Server on your control panel home page.
Click Add New MS SQL login icon:

Enter login and password into the MS SQL Login Creation Form that shows:

Note: you can change password by clicking the Change icon against the login name in the Controls section.

Click Submit button.
Agree to additional charges.

Note: To delete login, click the Trash icon against the login name, in Controls section.

9.3.2 Creating MS SQL Databases

To create a MS SQL database, do the following:

Click MS SQL Server on your control panel home page.
Click the Add database icon at the bottom of the page that appears:

Fill the MSSQL Database Creation form

Click the Submit button.
Agree to additional charges.

Note: To delete a database, click the Trash icon against the database name in Controls section.

When MS SQL creates a database, it automatically creates a user with the same *login* as the one this database was created with.

9.3.3 Adding New MS SQL Database users

After you have created the database, it appears in the database list:

Here you can learn how to add users to individual MS SQL databases.
To add a new user, do the following:

Click MS SQL Server on your control panel home page.
On the page that appears click the name of existing database or click the Edit icon in the Controls section. The following form will show:

At the bottom of the page click Add icon against Database users field. The following form will appear:

Enter user name and click Add.

When you are creating a new user to the database, the system offers you to choose from the logins that aren't used by this database.
It won't display this databse owner's login, because when MS SQL creates a database, it automatically creates a user with the same *login* as the one this database was created with. One login can be used only by one user within a database. So, login you have used to enter the database is already being used by you and can't be used to create a new user on this database.

Agree to additional charges if any.

9.3.4 Changing MS SQL Database quota

Total quota size is the disk space allocated for the database file and the transaction log file. Database/Transaction Log file quota ratio is the portion of disk space allocated for the database file. If you set the total quota size to 100 MB and the database/transaction log file quota ratio to 40%, then the maximum database file quota is 40 MB and the maximum log file quota is 60 MB. The more dynamic your database is, the bigger transaction log file quota ratio should be.

To change the quota, do the following:

Click MS SQL Server on your control panel home page.
On the page that appears click the name of an existing database.
On the form that shows, click the Change quota icon against the Database quota field.
Enter new database log file ratio and total quota size on the next page:

Click Submit.
Agree to additional charges if any.

9.4 Creating ODBC DSN Records

ODBC - Open DataBase Connectivity is a standard database access method developed by Microsoft Corporation. ODBC makes it possible to access any data from any application by means of ODBC drivers - one for each database format. You can create DSN (Date Source Name) records based on ODBC drivers to access databases of different formats under Windows plan.

To create a new DSN Record, do the following:

Click the ODBC icon on your home page control panel, and the list of available ODBC drivers will show.

Click the Add icon next to the DB driver you need.
Fill the form that appears. Forms are different depending on the DSN type:

Enter the second part of your full DSN name in the DSN field. Note: The first part of your full DSN name is your Windows login. In the applications/scripts you run on your server, you must use the full DSN name, e.g. testvi0-mydatabase as in the below example.

Directories and file names must include paths relative to your home dir root, (the SourceDB field should include the name of the database and the extension).

Click Create.

9.4.2 Editing DSN Records

Here you will learn how to edit your DSN records.

Note: For more details on each driver's parameters, please refer to the driver specification. E.g. you can find all information about MS SQL DSN configuration on the Microsoft Web Site at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_c_99yd.asp.

To edit DSN records, do the following:

Click the ODBC icon on your home page control panel.
On the page that shows, in the Your DSN section, click the Edit icon next to the DSN record you need.

Edit the DSN records in the form that appears.
Click Update

9.4.3 Deleting DSN Records

To delete a DSN record, do the following:

Click the ODBC icon on your home page control panel. This will open a page similar to the one above.
In the Your DSN section, click the Delete icon next to the existing DSN.