= Mysql Configuration =

[wiki:Installing Back to Installing]

Mysql configuration guide for gnuMims.

Default build/war settings:
 * Hostname = "gnumimssql01" (Setup DNS or add an entry to /etc/hosts)
 * Port = "3306" (The default MySQL port)
 * database = "gnumims_prod"
 * username = "gnumimsadmin" (This user must have all access to the database above)
 * password = "gnumimsadmin" (Having an open password is not a problem if MySQL is suitably firewalled and/or accepts only local connections)

Install Mysql and ensure the daemon is running.
If not already done, login and set root password:
{{{
$ mysql -u root
SET PASSWORD FOR root@localhost = password('CHANGE_TO_PASSWORD'); 
flush privileges; 
quit;
}}}

Create the database for gnuMims:
{{{
$ mysql -p -u root
CREATE DATABASE gnumims_prod;
USE gnumims_prod;
GRANT ALL ON gnumims_prod.* TO gnumimsadmin@localhost IDENTIFIED BY 'gnumimsadmin';
flush privileges; 
quit;
}}}