NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

Versions Compared

Key

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

...

Date entered: 01/09/2009

Answer

It depends. The LSD installation guide (pages 8 and 9) recommends setting up an empty database prior to any LSD tool installation, except for those tools that do not require a database (see table below).

...

Step 1: Login as an admin user (the root user or a user with administrative privileges). Create the caArray database via SQL commands as below:

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;

...