Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
75:system_requirements_mysql [2021/02/17 14:31] – [Native MySQL installation] bdss | 75:system_requirements_mysql [2024/02/16 18:23] (current) – [Required MySQL permissions] emr | ||
---|---|---|---|
Line 46: | Line 46: | ||
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/ | + | * ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, TRIGGER, UPDATE |
Additionally, | Additionally, | ||
- | * The SUPER privilege, globally: \\ <font inherit/ | + | * The SUPER privilege, globally: \\ '' |
- | * <font inherit/ | + | * If this is not desirable, binary logging has to be disabled. Add the following line to the MySQL configuration file: \\ '' |