Canīt add user to MySQL databases

Hi,

After upgrading MySQL to vers. 5.6.35 instead of the very old defayl version in cwppro, I am now unable to add database users to new databases

In the cwp interface I use 'create database + user' the output show that both are created, but checking in the list the user is not added.

If then clicking on the 'add new user' next to the new database, it shows the user is added, but when checking in the listing, it shows that the user is not added...

Very strange.

Anybody got an idea of how to solve this?

Running CWPPro 0.9.8.128

you can try seart on the forum. i can not find anywhere how can i fix this shit. manually add db on console.

mysql -u root -p
   
create database wordpress;

grant all on wordpress.* to 'user' identified by 'password';

quit