Stages Documentation

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
75:system_requirements_mysql [2020/06/26 15:50] – emr75:system_requirements_mysql [2020/09/02 06:26] – ndn
Line 28: Line 28:
  
 in ''database.properties''. in ''database.properties''.
 +===== Required MySQL Permissions =====
 +
 +The Stages user needs the following permissions for the database that is configured in database.properties
 +
 +  * <font inherit/Courier New,Courier,monospace;;inherit;;inherit>ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE</font>
 +
 +Additionally, one of the following is required
 +
 +  * The SUPER privilege, globally:  \\ <font inherit/Courier New,Courier,monospace;;inherit;;inherit>GRANT SUPER ON *.* TO 'stages'@'localhost';</font>
 +  * <font inherit/Arial,Helvetica,sans-serif;;inherit;;inherit>If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file:</font> \\ <font inherit/Courier New,Courier,monospace;;inherit;;inherit>disable_log_bin</font>