Issue Task Closed

#72199Review/update list of MySQL commands required

Michael Schams 12/14/15, 10:21 updated 02/09/20, 13:58

Description

Review and possibly update list of SQL commands required for the MySQL user.
The current requirements are documented [1] as follows:

The MySQL user needs a least the following privileges on the TYPO3 database:

* SELECT, INSERT, UPDATE, DELETE
* CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES

It is recommended to also grant the following privileges:

* CREATE VIEW, SHOW VIEW
* EXECUTE, CREATE ROUTINE, ALTER ROUTINE

Inspired by a discussion on the English TYPO3 mailing list [2] I decided to submit this ticket in order to review and clarify the MySQL requirements listed above and possibly update the list as required.

[1] https://git.typo3.org/Packages/TYPO3.CMS.git/blob_plain/refs/tags/7.6.0:/INSTALL.md
2 http://lists.typo3.org/pipermail/typo3-english/2015-December/094623.html

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.