Author Topic: Canīt add user to MySQL databases  (Read 7336 times)

0 Members and 1 Guest are viewing this topic.

Canīt add user to MySQL databases
« on: December 22, 2016, 02:44:32 PM »

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

Re: Canīt add user to MySQL databases
« Reply #1 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';