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 these schema manually via the MySQL command line console. 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. 

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;

...