Quick Start

Setup database

1. Create database mysql> CREATE DATABASE dbname;

   It is recommended that GenieGate be given it's own database. (in cases where multiple instances of ~/geniegate exist, separate databases are required)

2. Setup a user and grant permissions. mysql> GRANT ALL PRIVILEGES ON dbname TO username IDENTIFIED BY 'secret';

   Where dbname is the name of the database you are creating, usernameis the username for connecting to the database and secret is the password used in connecting to your database.

3. Flush the privileges so that you may connect.

   mysql> FLUSH PRIVILEGES;

   Your internet service provider may have provided you with tools to manage mysql databases. You should check with your ISP for the final word on creating and granting access to databases. In many cases, these steps will have already been done for you. More information about mysql, including security policies can be found at http://www.mysql.com/