Databases

Islandnet.com supports MySQL v4.x and MySQL v5.x

In the Control Panel you will find the following tools in the section Database Management:

Database Wizard

This tool lets you quickly create a new MySQL database/username/password combination on one of our database servers. Simply select the type and version of MySQL you wish to use, and choose a database, username, and password. Please note that the username and password you choose should be different from your Islandnet.com account username and password for security reasons. You can create as many databases as you need. Usernames and database names must be unique on each database server. If one or the other is already in use on the server you selected, either pick a different server or select a different value.

MySQL Manager

This tool is for the more expert MySQL users that may want to configure restrictions/privileges for the databases. Databases created with the Wizard appear herein so you can use the wizard to initially create the database and then use this tool to configure.

MySQL Users

In this table will appear existing MySQL users that you have configured, if you dont have any configured you can create users. One user can have many databases. Note that deleting a user does not delete associated databases but will remove the username associated with a database in the MySQL Databases table.

The Host entry is used to specify an IP address if you are wanting to restrict a user to only connect from that IP/Host. % is a wildcard that allows connection from anywhere and this is the default setting, it is rare that you would want to change this setting.

MySQL Databases

In this table will appear any databases you have created under this account, if you don't have any databases you can use the add icon to create them. To update an existing database you can make the changes in the fields for that database and click the update icon. Delete a database using the X icon. Note that deleting a database does not delete associated username in the above table.

The Host entry is used to specify an IP address/host if you are wanting to restrict connection to a database from, it would be in the form of an IP address. % is a wildcard that allows connection from anywhere and this is the default setting, it is rare that you would want to change this setting.

You can change privileges to a database but it is rage these need to be changed and should only be attempted experienced MySQL users.

• SEL - Select Priviledges

• INS - Insert Priviledges

• UPD - Delete Priviledges

• CRE - Create Priviledges

• IND - Index Priviledges

• ALT- Alter Priviledges

• DRP - Drop Priviledges

• LCK - Lock Priviledges

phpMyAdmin

Islandnet.com has 2 versions available for MySQL v4 and v5.