Setting up a mysql database for user management

Chapter 4. Setting up a mysql database for user management

You may skim over the database section if your ISP has already provided you with database creation tools. We will cover the manual steps required to install a mysql database, these instructions will vary depending on your ISP.

Procedure 4.1. Setup database

  1. Create database mysql> CREATE DATABASE dbname;

    It is recommended that GenieGate be given its 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, username is the username for connecting to the database and secret is the password used in connecting to your database. You will need this information later.

  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/