Changes between Initial Version and Version 1 of MysqlConfig

Timestamp:

Jun 28, 2010, 3:58:27 AM (14 years ago)

Author:

Gavin

Comment:

--

MysqlConfig

@@ +1 @@
+= Mysql Configuration =
+
+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;
+}}}
+
+