OrangeScrum - Revision history

Michael.mast: /* Apache Config */

2016-05-10T19:51:40Z

Apache Config

2016-05-06T18:01:52Z

2016-05-06T17:26:50Z

2016-05-06T16:49:52Z

2016-05-06T15:44:46Z

2016-05-06T15:43:57Z

2016-05-06T15:43:27Z

2016-05-06T15:41:17Z

2016-05-06T15:24:32Z

2016-05-06T15:22:32Z

@@ Line 9: / Line 9: @@
 <br>
-==DB Creation==<ref>https://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064</ref>
+==DB Creation==
 *<ref>https://support.kayako.com/article/472-how-do-i-disable-mysql-strict-mode-on-the-server</ref>Disable Strict Mode
 <pre>

@@ Line 12: / Line 12: @@
 *<ref>https://support.kayako.com/article/472-how-do-i-disable-mysql-strict-mode-on-the-server</ref>Disable Strict Mode
 <pre>
-MariaDB [(none)]> create database orangescrum collate utf8_unicode_ci;
+MariaDB [(none)]> CREATE DATABASE `orangescrum` CHARACTER SET utf8 COLLATE utf8_unicode_ci;
 MariaDB [(none)]> use orangescrum;
 MariaDB [orangescrum]> source /root/database.sql;

@@ Line 5: / Line 5: @@
 <br>
 NOTE : I had an old desktop laying around with 1GB of RAM and a single core Pentium M processor that I used for testing these servers out on. Ended up installing Fedora Server, which had some of the requirements baked in.
+==Apache Config==
 ==DB Creation==<ref>https://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064</ref>

@@ Line 5: / Line 5: @@
 <br>
 NOTE : I had an old desktop laying around with 1GB of RAM and a single core Pentium M processor that I used for testing these servers out on. Ended up installing Fedora Server, which had some of the requirements baked in.
 DB Creation<ref>https://www.euperia.com/development/mysql-create-database-with-utf8-character-set-syntax/1064</ref>
 <pre>
 MariaDB [(none)]> create database orangescrum collate utf8_unicode_ci;

← Older revision		Revision as of 15:44, 6 May 2016
Line 17:		Line 17:
	<ref>https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql</ref><pre>		<ref>https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql</ref><pre>
	MariaDB [(none)]> grant all privileges on orangescrum.* to 'orange'@'localhost';		MariaDB [(none)]> grant all privileges on orangescrum.* to 'orange'@'localhost';
		+	MariaDB [(none)]> flush privileges;
		+	MariaDB [(none)]> exit;
		+	</pre>

@@ Line 16: / Line 16: @@
 Please note that the above assumes orangescrum is running on the same server as the database, also orange as the password but this can be changed.
 <ref>https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql</ref><pre>
-MariaDB [(none)]> grant all privileges on orangescrum.* to 'orange'@'10.100.50.25';
+MariaDB [(none)]> grant all privileges on orangescrum.* to 'orange'@'localhost';