Changes between Version 10 and Version 11 of REDCap HowTo Install Using Docker

Timestamp:

09/19/16 16:00:13 (9 years ago)

Author:

saj.issa

Comment:

--

REDCap HowTo Install Using Docker

@@ -3 +3 @@
 [[Docker HowTo Install]]
 
-== Prerequisites
+== Prerequisites if required
 
 '''Step 1 - Install Git''' 
@@ -25 +25 @@
     {{{mysql -u root -p}}}
 
-Create a database, make sure you postfix with Redcap version number
+Create a database, make sure you postfix with Redcap version number. Please stick to this naming convention. 
 
     {{{mysql > create database redcap6168}}}
@@ -32 +32 @@
 
     {{{mysql -u root -p -h localhost redcap6168 < 19-09-2016-_redcap.sql}}}
+
+'''Step 3 - Create / Grant Mysql permissions'''
+
+If a new user is needed run the following, replace necessary details
+
+    {{{CREATE USER 'briccsext02_user'@'uhlbriccsext02.xuhl-tr.nhs.uk' IDENTIFIED BY 'password'}}}
+
+Grant necessary privileges to user.
+ 
+    {{{GRANT USAGE ON *.* TO 'briccsext02_user'@'uhlbriccsext01.xuhl-tr.nhs.uk' IDENTIFIED BY 'password'}}}
+    {{{GRANT ALL PRIVILEGES ON redcap6168_briccsext.* TO 'briccsext02_user'@'uhlbriccsext01.xuhl-tr.nhs.uk';}}}
+    {{{GRANT ALL PRIVILEGES ON redcap6168_briccsext.* TO 'briccsext02_user'@'uhlbriccsext02.xuhl-tr.nhs.uk';}}}
+
+If user already exists
+
+    {{{GRANT ALL PRIVILEGES ON redcap6168.* TO 'redcap'@'10.156.254.207';}}}
+
+or
+
+    {{{GRANT ALL PRIVILEGES ON redcap6168_briccsext.* TO 'briccsext_user'@'uhlbriccsext01.xuhl-tr.nhs.uk';}}}
+
+
 
 There are 3 docker scripts available from github :