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 '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'

CentOS: locate it at /etc/mysql/my.cnf

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