NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 23

changes.mady.by.user Unknown User (dilmanih)

Saved on

compared with

New Version 24

changes.mady.by.user Unknown User (dilmanih)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Manually Creating The Requisite Database Schema

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, log into the console using the root password you set when installing the database server, then enter the following SQL commands line-by-line:

Code Block
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;

...