A product from

• Frequently asked questions
• News archive
• Blog
• Help and tutorials
  • User Interface
  • Functions and tools
  • Configuration and customization
    • Album sorting and grouping
    • Artist Grouping
    • Auto Enqueue options
    • Change Track Details columns
    • Customize toolbar
    • Customizing a Music Explorer node
    • Equalizer
    • Library management
      • Create new Microsoft SQL Server database
      • Create new MySQL database
      • Import Music Browser data
      • Open a Microsoft SQL Server database
      • Open a MySQL database
    • Options
    • Select Play Queue columns
    • Track List sorting and grouping
  • Detailed information
  • Tutorials, tips and tricks
• Forum
• Customer Center
• Contact us
• About us

Create new MySQL database

Creating a new MySQL Database

Before you can create a new MySQL database you must have setup a working connection to MySQL - see this guide on how to this.

1. Click Advanced > Library > Management from the main menu to launch the Library Management dialog. You can also press CTRL-D on your keyboard.
2. Click on the MySQL databases tab.
3. Click the New button on the toolbar.
4. If you have installed the MySQL Server on a different computer than the one you are running Helium Music Manager you you need to enter the computer name or IP address of that computer in the Server Name box, otherwise just leave this at the default "localhost". A computer on your network might be accessible for example as '192.168.0.12' or '\\Home_Server'.
5. Enter the Port number to access MySQL - typically this is 3306 (which is the default) unless you have configured a different port number.
6. Under Login Options type in the MySQL user name in the User Name box and the password for the user in the Password box. Unless you have defined a specific user and set their administrative rights, you should specify the user name "root" and the password for that user (If you have used our guide on how to install MySQL - this is the password set in step 9.)
   
7. Click the Refresh button to get a list of databases already created on the server. Enter the name of the database you want to create in the Database Name edit box e.g. helium. Make sure that no database with the same name already exists.
8. Click the OK button.

Helium Music Manager will now create and connect to the new MySQL database.