ISPConfig not creating users in MySQL 8

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)

 

Hi,

Sorry to jump on an old thread, but I have exactly the same problem with the same debug output.
Can I ask how you fixed this?

Code:

09.04.2022-12:00 - DEBUG [server:177] - Found 3 changes, starting update process.
09.04.2022-12:00 - DEBUG [plugins.inc:118] - Calling function 'db_user_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_insert'.
09.04.2022-12:00 - DEBUG [modules.inc:240] - Processed datalog_id 1251
09.04.2022-12:00 - DEBUG [plugins.inc:118] - Calling function 'db_user_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_user_update'.
09.04.2022-12:00 - DEBUG [modules.inc:240] - Processed datalog_id 1252
09.04.2022-12:00 - DEBUG [plugins.inc:118] - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
09.04.2022-12:00 - DEBUG [mysql clientdb plugin.inc:280] - Created MySQL database: c1_testing
09.04.2022-12:00 - DEBUG [mysql clientdb plugin.inc:107] - Calling GRANT for c1_testing with access rw and hosts localhost
09.04.2022-12:00 - DEBUG [mysql clientdb plugin.inc:113] - GRANT for user c1_testing at host localhost
09.04.2022-12:00 - DEBUG [mysql clientdb plugin.inc:151] - CREATE USER 'c1_testing'@'localhost'
09.04.2022-12:00 - DEBUG [mysql clientdb plugin.inc:170] - PASSWORD SET FOR 'c1_testing'@'localhost' success? yes
09.04.2022-12:00 - DEBUG [mysql clientdb plugin.inc:178] - GRANT ALL PRIVILEGES ON `c1_testing`.* TO 'c1_testing'@'localhost' success? no
09.04.2022-12:00 - DEBUG [modules.inc:240] - Processed datalog_id 1253
09.04.2022-12:00 - DEBUG [server:217] - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock

Root password is correct and set in in /usr/local/ispconfig/server/lib/mysql_clientdb.conf
Root user has full privileges and ispconfig user has super.

The issue started after an OS update from Ubuntu 18 > 20.
After the OS update I ran the update script with the force flag and everything else is running fine.

Thanks for any pointers!