Databases

If you have ordered this service you will be able to use MySQL databases. This manual is not intended to describe databases, since there are many online resources. Only HOSTEX specific information on database usage is covered here. When you order MySQL support you are provided with database, which name is the same as your domain name only with "_" instead of ".". For example if your domain name is mydomainname.com then your database name is mydomainname_com. If you need more databases, you can add them by clicking on "Add new database" in Server Administration section of your virtual server. Please remember that additional databases are $1 per database / month and dots are not allowed in database names.

For administration of the database you should make an Access User in Control Center and grant him rights to access the database. After setting Access User from the Control Center you can run the Database Administration Tool at https://www.hostex.net/cgi-bin/dbadmin.cgi.

For database access from php scripts you should use mysql_ functions group. For connection to the database use "localhost" hostname, any of the Access Users having permissions to access the database username and Access User's password.
For example:
mysql_connect ("<localhost>", "access_user", "password");

For the selection of the database set the database_name variable to your server name:
mysql_select_db ("<yourdomain>");

For the access to the database from CGI scripts you should use DBI module. For the connection to database execute command:
data_source - "dbi:mysql:localhost", user and password as in php case. For example:
DBI->connect("dbi:mysql:<yourdomain>", "access_user", "password");

For connection to the database from ODBC in the Control Center make an access user and grant him permission to access the database from the ODBC. Then get the ODBC mysql drivers from: http://www.mysql.com/downloads/index.html .And point your host to your domain. You should make the following changes in the database: set server, <yourdomain> user - one of the Access User with access via ODBC rights and his password.