Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
75:system_requirements_mysql [2020/09/02 06:26] – ndn | 75:system_requirements_mysql [2020/09/02 07:01] – [Required MySQL Permissions] ndn |
---|
| |
in ''database.properties''. | in ''database.properties''. |
===== Required MySQL Permissions ===== | ===== Required MySQL permissions ===== |
| |
The Stages user needs the following permissions for the database that is configured in database.properties | 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> | * <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 | 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: \\ <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> | * <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> |
| |
| |