Creating and connecting to a MySQL database

In order to best support backward compatibility and forward growth, Interkey.net supports both MySQL 4.1 and 5.0 database engines. Many applications written for MySQL 4.1 are incompatible with MySQL 5.0 due to better ANSI SQL compliance in MySQL 5.0. If you are creating a database for a script or web application which does not specify the MySQL version you should use and you are unsure, use MySQL 4.1.

Creating a MySQL database

• Log into the user control panel at https://my.interkey.net.
• From the menu at the top of the page, choose Settings.
• Locate the hosting plan under which you wish to create the database.
• Locate the heading for the version of MySQL under which you wish to add a database.
• At the right of this heading, click the Add button.
• Enter a database name, and a username and password that will be used to access this database. The database name and the username must be unique. When you are finished, click Save.

Connecting to a MySQL database

In your MySQL database tool of choice, enter the following values:

• Hostname: mysql.yourdomain.com
• Port: 3306 for MySQL 4.1 or 3307 for MySQL 5.0
• Username: yourusername
• Password: yourpassword
• Database: yourdatabase