Installation: Create the production database

Notes

The production database stores user data and other information related to hydraDAM.

Steps

Create the mysql databases for your production server.

1. Change the mysql default character set to be utf8.
   Edit the mysql configuration file '/etc/mysql/my.cnf' as root to add the following lines after [mysqld]:

character-set-server=utf8
collation-server=utf8_unicode_ci
init-connect='SET NAMES utf8'

1. Log in to mysql: mysql -u root -p
   Enter mysql root pw, which you set when you configured mysql-server. These instructions are shown with the mysql prompt and the expected output. To copy the commands into your shell, copy everything AFTER the > up to the semicolon; the expected output is shown in italics.
   mysql> CREATE DATABASE hd_production;
   Query OK, 1 row affected (0.00 sec)
   mysql>

GRANT ALL ON hd_production.* TO hdProd@localhost IDENTIFIED BY 'hdProd';

Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye

Verification/Validation Steps

Next Step

Proceed to Create and Configure the YML Files or return to the Overview page.