Setup a MySQL database

You choose a user password, then the included script creates the user, the database and the necessary tables for you:

1. pick a password and set it in the script file. Edit scripts/greylite-mysql.sql and set your preferred password in the third line
2. run the script into the server:

   mysql < scripts/greylite-mysql.sql
   

Done.

Control variables

You will need the following environment variables for this database configuration:

DBRESOURCE=":greylite:yourpassword:greylite::/tmp/mysql.sock"

See greylite controls for more information.