Changes between Version 13 and Version 14 of Opal HowTo Install

Timestamp:

07/02/15 12:52:12 (9 years ago)

Author:

Richard Bramley

Comment:

--

Opal HowTo Install

@@ -86 +86 @@
 '''Actually these both look OK, with the exception that the collation is utf8_general_ci, so I will just change that'''
 
+=== 2. Create Databases
+
+1. Create the following script:
+
+{{{
+# Create Opal database and user.
+#
+# Command: mysql -u lampuser -p < create_opal_database.sql
+#
+ 
+CREATE DATABASE opal_data CHARACTER SET utf8 COLLATE utf8_bin;
+ 
+CREATE USER 'opal_data' IDENTIFIED BY '<opal-data-user-password>';
+GRANT ALL ON opal_data.* TO 'opal_data'@'localhost' IDENTIFIED BY '<opal-data-user-password>';
+FLUSH PRIVILEGES;
+
+CREATE DATABASE opal_identifiers CHARACTER SET utf8 COLLATE utf8_bin;
+ 
+CREATE USER 'opal_identifiers' IDENTIFIED BY '<opal-identifiers-user-password>';
+GRANT ALL ON opal_identifiers.* TO 'opal_identifiers'@'localhost' IDENTIFIED BY '<opal-identifiers-user-password>';
+FLUSH PRIVILEGES;
+}}}
+
+2. Change the passwords to something appropriate
+3. Run the script like it says in the command comment at the top of the script.
+
 == Installing RServe