Project

General

Profile

Actions

Task #72199

closed

Review/update list of MySQL commands required

Added by Michael Schams almost 9 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Documentation
Target version:
-
Start date:
2015-12-14
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
7
PHP Version:
Tags:
Complexity:
Sprint Focus:

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

Actions

Also available in: Atom PDF