ISPConfig not creating users in MySQL 8

Discussion in 'Installation/Configuration' started by someB0dy, Nov 13, 2021.

  1. someB0dy

    someB0dy New Member

    Hi all,
    A help needed, the ISPConfig is not creating users on MySQL8.
    System: Ubuntu 20.04.3
    ISPConfig latest: 3.2.7p1
    MySQL: 8.0.26

    Tried other threads with similar subject, issue not fixed. With debug log it seems that ISPConfig is using wrong methods for mysql8, e.g.:


    Code:
    13.11.2021-09:16 - DEBUG - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'.
    13.11.2021-09:16 - DEBUG - Processed datalog_id 175
    13.11.2021-09:16 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
    13.11.2021-09:16 - DEBUG - Created MySQL database: c3test3
    13.11.2021-09:16 - DEBUG - Calling GRANT for c3test3 with access rw and hosts localhost
    13.11.2021-09:16 - DEBUG - GRANT for user c3test at host localhost
    13.11.2021-09:16 - DEBUG - CREATE USER 'c3test'@'localhost'
    13.11.2021-09:16 - DEBUG - PASSWORD SET FOR 'c3test'@'localhost' success? yes
    13.11.2021-09:16 - DEBUG - GRANT ALL PRIVILEGES ON `c3test3`.* TO 'c3test'@'localhost' success? no
    The mysql query log is similar:

    Code:
    CREATE DATABASE `c3test3` DEFAULT CHARACTER SET utf8
    CREATE USER 'c3test'@'localhost'
    ALTER USER IF EXISTS 'c3test'@'localhost' IDENTIFIED WITH mysql_native_password AS '*XYZ'
    GRANT ALL PRIVILEGES ON `c3test3`.* TO 'c3test'@'localhost'
    Doing same manually as a root user with needed permissions:
    Code:
    mysql> GRANT ALL PRIVILEGES ON `c3test3`.* TO 'c3test'@'localhost';
    ERROR 1410 (42000): You are not allowed to create a user with GRANT
    The CREATE USER query should be followed with 'IDENTIFIED BY pwd' as I believe.

    Edited, with same root user to show GRANT is allowed:
    Code:
    mysql> CREATE USER 'supertest'@'localhost' IDENTIFIED BY '07F9D2B56375046CD5A6E748B542DBE7928FED8Bdf';
    Query OK, 0 rows affected (0.03 sec)
    mysql> GRANT ALL ON c3test5.* TO 'supertest'@'localhost';
    Query OK, 0 rows affected (0.03 sec)
    
     
    Last edited: Nov 13, 2021
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Check all root user(s) in your mysql database and ensure that they all have all available permissions incl. grant privilege.
     

Share This Page