Installation: Create the production database

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