MySQL Database Setup

This has been tested with MySQL 5.5.22 but should work with MySQL 5.0.77+
provided InnoDB is included.

Start by logging into your database server as root. Create the killboard
database and kbadmin account and be sure to replace the PHP_is_Right_Out!
password with something clever, easy to type in, yet hard to guess.

/home/ddrouin> mysql -uroot -p

mysql> create database killboard default character set utf8
default collate utf8_unicode_ci;
mysql> create user 'kbadmin'@'localhost' identified by 'PHP_is_Right_Out!';
mysql> grant all on killboard.* to 'kbadmin'@'localhost';

Exit from mysql and then run the follow from within your pykb-code/pykb/sql/mysql
directory:

cat ccp.sql | mysql --local-infile -ukbadmin -p --database=killboard
cat pykb.sql | mysql --local-infile -ukbadmin -p --database=killboard
cat update_aggregates.sql | mysql --local-infile -ukbadmin -p --database=killboard

The --local-infile is to avoid this error:
ERROR 1148 (42000) at line 4: The used command is not allowed with this MySQL version

Another way is to edit /etc/mysql/my.cnf and add the entry below and
then restart mysqld (mysql on Ubuntu).
[mysql]
local-infile

Before adding any kill mails into your database you'll most likely want to have pricing data present - see [Updating Prices] along with [Aggregation] running so that summary tables will be kept up to date.

Edit this file to see the proper connection string info to reach the killboard database as kbadmin:

/home/ddrouin/pykb-code/pykb/conf/pykb.yml

Ensure that the PostgreSQL related section is commented out or deleted