Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added instructions to create mysql database and user with full access

...

A working copy of NMIS that opExport can read and export the data from, and a running MySQL server.

MySQL Database / User

To create a new mysql database you will need to run a command like this 

Code Block
mysqladmin create opexport -p #if you haven't set a password you can leave out the -p, if you need to run as a different user add -u user_name 

After creating a new database you will want to create a new user and grant them access to the new database:

Code Block
mysql -u root -p
mysql> CREATE USER 'opexport'@'localhost' IDENTIFIED BY '42opexport42';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON opexport.* to 'opexport'@'localhost';
Query OK, 0 rows affected (0.01 sec) 

Installation Steps

Common Steps

...