Setup MySQL database connection - nordpos/nordpos GitHub Wiki

For Linux

1. Create new database.

$ mysql -u user_name -p

CREATE DATABASE nordpos_db;

or (if you have exists database)

1. Create database back-up.

$ mysqldump -h localhost -u user_name -p nordpos_db > nordpos_db.sql

2. Create user and grant the access for NORD POS database.

$ mysql -uroot -p

CREATE USER 'nordposuser'@'localhost' IDENTIFIED BY 'nordpospass';
GRANT ALL PRIVILEGES ON nordpos_db . * TO 'nordposuser'@'localhost';
FLUSH PRIVILEGES;

3. Run application for configuration.

$ ./configure.sh

4. Setup database connection:

• select database type MySQL;
• change path for driver library(by-default JDBC libraries placed in lib-jdbc folder of application);
• set connection URL to your database jdbc:mysql://localhost:3306/nordpos_db?useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8;
• enter user name nordposuser and password nordpospass.

5. Disable start-up of Apache Derby Network Server.

6. Save configuration changes and start NORD POS.

$ ./start.sh

7. Allow create new database.

or

7. Allow database upgrade.

8. After run initiation scripts, the application deploy(or upgrade) NORD POS database into your MySQL Server and run login panel.

Finish