Changes between Initial Version and Version 1 of MysqlConfig


Ignore:
Timestamp:
Jun 28, 2010, 3:58:27 AM (15 years ago)
Author:
Gavin
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • MysqlConfig

    v1 v1  
     1= Mysql Configuration =
     2
     3Mysql configuration guide for gnuMims.
     4
     5Default build/war settings:
     6 * Hostname = "gnumimssql01" (Setup DNS or add an entry to /etc/hosts)
     7 * Port = "3306" (The default MySQL port)
     8 * database = "gnumims_prod"
     9 * username = "gnumimsadmin" (This user must have all access to the database above)
     10 * password = "gnumimsadmin" (Having an open password is not a problem if MySQL is suitably firewalled and/or accepts only local connections)
     11
     12Install Mysql and ensure the daemon is running.
     13If not already done, login and set root password:
     14{{{
     15$ mysql -u root
     16SET PASSWORD FOR root@localhost = password('CHANGE_TO_PASSWORD');
     17flush privileges;
     18quit;
     19}}}
     20
     21Create the database for gnuMims:
     22{{{
     23$ mysql -p -u root
     24CREATE DATABASE gnumims_prod;
     25USE gnumims_prod;
     26GRANT ALL ON gnumims_prod.* TO gnumimsadmin@localhost IDENTIFIED BY 'gnumimsadmin';
     27flush privileges;
     28quit;
     29}}}
     30
     31