Helium Music Manager with MYSQL

Introduction

To use MySQL with Helium Music Manager you have to install MySQL, it is available for download on MySQL's website http://www.mysql.com. You will also need to install the MySQL Connector/ODBC to be able to connect to the server from Helium Music Manager.

Helium Music Manager works with version 4.1+ and 5.0+ of MySQL, and the MySQL Connector/ODBC has to be version 3.51.23+. Other versions of the ODBC Connector does not work with Helium Music Manager.

MySQL Connector/ODBC Version 3.51.23+ can be downloaded here:

http://dev.mysql.com/downloads/connector/odbc/3.51.php

Creating a new Database

From Helium Music Manager:

1. Open the Database Management dialog by clicking Tools | Database | Management in the mainmenu.

2. Click on the tab MySQL databases

3. Click the new button to open the Create new MySQL database dialog

4. Enter the servername in the first edit box, for locally installed MySQL you can enter localhost and for remote servers you should use the IP or DNS-name for the server.

5. Enter the portnumber, standard for MySQL is 3306 if you haven't changed it

6. Enter user name and password, note that you have to connect with a user that has access to create a new database unless you already has created an empty database with that name on the server.

7. Enter the name of the database you want to create in the second edit box, you can use the refresh button to get a list of databases already created on the server so you don't try to create a database that already exist.

8. Click the OK button, Helium Music Manager will try to create and connect to the new database.

Opening an existing database

From Helium Music Manager:

1. Open the Database Management dialog by clicking Tools | Database | Management in the mainmenu.

2. Click on the tab MySQL databases

3. Click the open button to open the Open MySQL database dialog

4. Enter the servername in the first edit box, for locally installed MySQL you can enter localhost and for remote servers you should use the IP or DNS-name for the server.

5. Enter the portnumber, standard for MySQL is 3306 if you haven't changed it

6. Enter user name and password, note that you have to connect with a user that has access to create a new database unless you already has created an empty database with that name on the server.

7. Click on the refresh button to connect and get a list of all databases on the server.

8. Select the database you want to open and click OK to open it.

Note:

Connecting to a remote server requires that the remote server allows remote connections