MySQL - Quick Start Guide

Before installing wimpy you should have the following already set up:
- A MySQL username and password. The user should have all priviliages.
- A MySQL database name (i.e. a database must already exist -- wimpy will create and use a table on this database, you do NOT have to establish the table before installation. The only thing that needs to be established is a database.)

Step 1 - Set configuration variables
Open wimpy_mysql_config.php in a text editor and set the variables to match the username, password and database settings for your MySQL connection.

Step 2 - Upload wimpy + a couple MP3 files
Upload all of the MySQL connection script files to the same directory that contains your MP3 files. The directory that contains your mp3 files will be refered to as "your wimpy directory" and we will assume that your "wimpy directory" is named "mp3s."
- wimpy.php
- wimpy.swf
- myWimpy.php       <-- the HTML code in this file was generated using the online customization tool at
- wimpy_mysql_config.php
- wimpy_mysql_get.php
- wimpy_mysql_update.php

For testing purposes, only upload a couple MP3 files + the example.mp3 file that came in the demo package... You can download the demo package again by
- example.mp3
- one_of_yours.mp3
- two_of_yours.mp3


Step 3 - Add files to the Database
Access the following page with your browser: wimpy.php with the following command: ?action=updateMySQL.


Step 4 - Test Your MySQL Connection
Access the following page with your browser: wimpy_mysql_get.php

The first line of the resulting page should display a long string of text that will look similiar to:


If you receive an error, check your wimpy_mysql_config.php settings and make sure that the variables are all correct. Also make sure that the user your defined is associated with your database and has full proviledges to modify the database.

If you do not receive an error, upload a couple more mp3 files, don't go crazy just yet, only upload about 5 or so. After the new mp3 file have been uploaded, repeat step 3 (above) to update the database with the new files.


Step 5 - Use the online customization tool
Got to the following link to generate code for the myWimpy.php page on your web site.

When entering the last couple of questions: "Where is wimpy.swf? and "Where is your wimpy PHP file?" - be sure to use a full URL path to the files.


Copy and paste the resulting code into the myWimpy.php page, then upload it to your server.

Step 6 - Load Wimpy
Access the following page with your browser: myWimpy.php

The resulting page should show wimpy and ALL of the songs located in your database. Since no search criteria was sent in, wimpy display's all of the songs in the database.


Step 7 - Load a Playlist / Specifying Search Criteria
Access myWimpy.php with your browser again, but this time tack on the the following command to the URL:

?queryWhere=artist&QueryValue=Mike Gieson

Example: Gieson

The resulting page should only load a single file. The file that loads is the example.mp3 file that shipped with wimpy. In the playlist, you will see the id3 information for that file, not the file name.