Control Web Panel

WebPanel => MySQL => Topic started by: muscator on December 22, 2016, 02:44:32 PM

Title: Canīt add user to MySQL databases
Post by: muscator on December 22, 2016, 02:44:32 PM
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


Title: Re: Canīt add user to MySQL databases
Post by: crmgddn63 on December 22, 2016, 11:02:07 PM
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