2.0 - Getting Started

It doesn't take much to get started using qcdorganizer. Below are outlined the basic steps needed:

• 2.1 - Database Initialization
• 2.2 - Detecting Connected Organizers
• 2.3 - Connecting to the Database

2.1 - Database Initialization

Setting up a database under mysql is easy. First, install mysql. Check your OS procedures for doing so if you're running a Unix variant, or go grab it from their website if you're running windows. Follow your OS or website instructions on setting the database up for general usage.

Now, the first thing you want to do when mysql is up and running is to create a database to use. To do this, log into mysql with an account that has permission to create a database and run the following:

CREATE DATABASE myDatabase;

Where myDatabase is the name of the database you want to create.

Next, you want to add a user to access that database. To do this, log into mysql with an account that is capable of granting user access and enter the following:

GRANT CREATE,INSERT,UPDATE,SELECT ON myDatabase.* TO 'myUser'@'myHost' IDENTIFIED BY 'myPassword';

Below the above parameters are described:

• myDatabase - This is the same database name that you entered in the previous command. Enter it here. Remember that it is case sensitive
• myUser - This is the user name used to connect to the database. The point of this command is to create a user who only has access to the cd organizer portion of the database, so make sure it's a unique user
• myHost - This is the Host Name or IP address you will be connecting from. If the database and qcdorganizer are on the same machine, use localhost. This prevents unauthorized external access. If you want to override this and be wide open for connections from anywhere, use %
• myPasswordThis is the password used to connect to the database. Remember that it is case sensitive

And that's it. You now have a functional database. qcdorganizer will take it from there.

2.2 - Detecting Connected Organizers

2.3 - Connecting to the Database