Bug #78885
Updated by Sybille Peters over 6 years ago
With a fresh TYPO3 8.4 installation, it seems not possible to successfully run the installation wizard when
* there are multiple databases,
* the database user intended for installation
* has the global privilege @SHOW DATABASES@,
* has full privileges for the database intended for TYPO3,
* has no privileges for all the other databases.
As soon as the database credentials are entered and submitted, it seems *all databases* get examined (e.g. for existing tables). During this process, the installer obviously even tries to access the databases which the given user has no access privileges for, resulting in the following error (see attached screenshot as well):
> An exception occured in driver: Benutzer 'username'@'localhost' hat keine Zugriffsberechtigung für Datenbank 'bla'
(Translation: "User 'username'@'localhost' has no access privileges for database 'bla'". "username" and "bla" have been replaced in the error message. "bla" is another existing database which "username" has no access privileges for.)
After the first appearance of the above mentioned error, the installation attempt cannot be continued under no circumstances ("Oops ..." for all actions; no restart possible). All resources generated by the install tool have to be removed (which practically is a completeley fresh install).
The exact same setup worked (and works) flawlessly with TYPO3 7.x (and possibly before; not sure about TYPO3 8.0 - 8.3, didn't try these).
The only solution right now is to give the database user full access privileges for all databases — which works but surely isn't a viable solution.
h2. Updates:
* 20.May 2018 (Sybille Peters): Added Steps to reproduce : https://forge.typo3.org/issues/78885#note-5