Database Setup

Owned by Torsten Schmidt
Last updated: Oct 19, 2018 by Robin Sachse

The database setup is done in: https://github.com/schmto/nmsprime/blob/dev/Install/after_install.sh

# mysql enable
systemctl start mariadb
systemctl enable mariadb

# set root and make sql production
# mysql_secure_installation

# create mysql db
mysql -u root -e "CREATE DATABASE nmsprime;"
pw=$(pwgen 12 1) # SQL password for user nmsprime
mysql -u root -e "GRANT ALL ON nmsprime.* TO 'nmsprime'@'localhost' IDENTIFIED BY '$pw'";