Page History

...

It is possible to have Ant automatically generate the empty database schema required for caArray to work. However, it is preferred to generate create these schema manually via the MySQL command line consoleclient. First, you need to derive a name for the database caArray will use to store genomic data (i.e., DB NAME), as well as a username (i.e., CAARRAY DB USER) and password (i.e., CAARRAY DB USER PASSWORD) for the user who is granted access to that database.  In our example, the database name is db1, the username is user1, and the password name is password1.

Now, log into the console using the root password you set when installing the database server, then enter the following SQL commands line-by-line, substituting the database name, username, and password you derived where indicated:

CREATE DATABASE <DB NAME> DEFAULT CHARACTER SET latin1;
GRANT ALL ON <DB NAME>.\* TO '<CAARRAY DB USER>'@'localhost' IDENTIFIED BY '<CAARRAY DB USER PASSWORD>' WITH GRANT OPTION;
GRANT ALL ON <DB NAME>.\* TO '<CAARRAY DB USER>'@'%' IDENTIFIED BY '<CAARRAY DB USER PASSWORD>' WITH GRANT OPTION;

The client will respond with a confirmation that the issued queries were successful, as shown in the screenshot below: Image Added

Configuring The Various Properties Files Required By Ant

...