ISPConfig fails to create ispconfig user during initial installation with MySQL 8.0.14
I'm trying to install ispconfig on a machine that did not have it before, but it's halting on this step: ERROR: Unable to create database user: ispconfig Error: and wouldn't proceed any further
Installer script should proceed further, but won't if running MySQL 8 since creating users using GRANT statement is removed in 8.
Server OS: Ubuntu server Server OS version: 18.04 x64 ISPConfig version: https://git.ispconfig.org/ispconfig/ispconfig3/repository/archive.tar.gz?ref=stable-3.1 that one
I found a workaround here https://www.eninsoft.com/instalacion-de-ispconfig-3-x-en-debian-9-mysql8-version-optimizada/ But proper fix would be to create user according to mysql 8 guidelines without GRANT statement usage.
Starting with MySQL 8 you no longer can (implicitly) create a user using the GRANT command. Use CREATE USER instead, followed by the GRANT statement:
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'root'; mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;