// Grant appropriate permissions for  people to access

create database INODE DEFAULT CHARACTER SET utf-8;
grant all on INODE.* to 'k-int'@localhost identified by 'k-int';
grant all on INODE.* to 'k-int'@localhost.localdomain identified by 'k-int';
grant all on INODE.* to 'k-int'@'%' identified by 'k-int';
FLUSH PRIVILEGES

 

Useful info.. Here is my my.cnf file from /var/lib/mysql

[mysqld]
default-table-type=InnoDB
# Comments start with hash
# Test logging
log=/var/log/mysqld.log

This makes default table type innodb and logs important things to /var/log/mysqld.log

The following index helps with performance of the place table
create index PAF_KEY_IDX_2 on KIIE_PLACE(PAF_KEY,PLACE_TYPE);