Differences

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

--- 75:system_requirements_mysql [2020/12/10 16:21] – emr
+++ 75:system_requirements_mysql [2024/02/16 18:23] (current) – [Required MySQL permissions] emr
@@ Line 10: / Line 10: @@
 character-set-server=utf8
 max_allowed_packet=500M
-innodb_lock_timeout=600
+innodb_lock_wait_timeout=600
 transaction-isolation=READ-COMMITTED
 lower_case_table_names=1
@@ Line 23: / Line 23: @@
 The Windows 7 search feature causes the same kind of problems as a virus scanner. Please disable this feature on the Stages server.
 ===== Azure MySQL DB =====
@@ Line 45: / Line 46: @@
 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>
+  * ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE
 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>
+  * The SUPER privilege, globally: \\ ''GRANT SUPER ON *.* TO 'stages'@'localhost';''
-  * <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>
+  * If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file: \\ ''disable_log_bin=1''