|
| DOCUMENTATIONS |
 Documentations
Part 9 - Hosting databases |
|
|
|
|
|
|
|
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.
|
|
Creating MySQL Database and Its
Users |
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.
|
|
| 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.
|
|
| 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.
|
|
| 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.
|
|
| 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 privil
eges 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. |
|
|
|
|
| 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.
|
|
| 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.
|
|
| 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. |
|
|
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.
|
|
|
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
|
|
|
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.
|
|
|
|
|
| Hosting
Microsoft SQL Databases |
| Microsoft SQL Server is a relational
database management system produced by Microsoft
back in 1989. It supports a superset of Structured
Query Language (=SQL), the most common database
language. It is commonly used by businesses for
small to medium sized databases, and in the past
5 years large enterprise databases and competes
with other relational database products for this
market segment.
Unlike other SQL database management systems
(=DBMS), MS SQL requires a login to access the
MS SQL server. Once you have created a login,
you can create databases. To access a database,
you need to create database users.
You may follow these steps below in order to
achieve a working MS SQL environment
- Creating Microsoft SQL logins
- Creating Microsoft SQL databases
- Adding MS SQL database users
- Changing MS SQL quota
- Managing MS SQL databases through web-interface
(MS SQL Manager)
|
|
| 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. |
|
| 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. |
|
|
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.
|
|
|
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.
|
|
|
|
|
| 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. |
|
| Creating
a new DSN Record |
| 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. |
|
| 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
|
|
|
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.
|
|
|
|
|
|
|
|
Overview
Sales Line
