MySQL Integration

MySQL is a Linux based ODBC (Open DataBase Connectivity) compliant database system.  What this means is that the database has coding that when accessed using the correct drivers can allow a user to link to the MySQL database from a compatible database on their own machine.

Virtual Server Set Up

In order to set up your database you will need to email support@hubnut.net with the following details:

• Your domain

• A Username (can be different from your Virtual Server Name)

• A password (can be different from your Virtual Server Name)

The database name will be based on your domain i.e. domain_db.  Once requested we will activate your database within 48 hours and confirm this via email.  Each database can have any number of tables dependent on disk allowance.

Connecting to MySQL

You can connect to your database using SSH Telnet, once logged into the system you can access MySQL using the following command:

mysql -u username -p databasename

You will then be prompted for your password which when typed in will place you at the MySQL prompt.  For information on commands that are available please refer to the online documentation at the MySQL web site.

Alternatively you can connect to MySQL via PHP3.  The basic command that you need to use in your PHP page is:

$mysql_link = mysql_connect("localhost", "<username>", "<password>");

This is the command required to connect to the database. Details of commands needed to communicate with the database are found on the PHP web site.

If you have a fixed IP address then on request to support@hubnut.net you may also connect to MySQL using MyODBC from an ODBC database on your own computer such as Microsoft Access, FoxBase, DBase Pro.  To integrate this connection you will require MyODBC drivers that you can download from http://www.tcx.se/download_myodbs.html   The setting that you will require to connect to the MySQL database via ODBC are:

• Hostname - your domain name

• MySQL database name -the name of your database

• Username - database username

• Password - database password

• Port - 3306

Please note that we only make MySQL available on our servers.  We cannot support development related MySQL issues.  You may consider taking out support from MySQL directly.

 Email : support@hubnut.net 

© 1999-2004, HubNut Limited - Registered in England and Wales no. 3932100