Control Web Panel

WebPanel => MySQL => Topic started by: eternity on April 19, 2015, 09:15:26 PM

Title: No user assigned to db
Post by: eternity on April 19, 2015, 09:15:26 PM

Whenever I'm creating new database (new user also gets created with same db name) the users are not assigned to the db.

Several weeks before I've upgraded MySQL using ssh to latest version (5.6.x). Could be something messed up there as I've never created db then.

So how to solve the db issues

When new domains / users are added even they dont show up unless they are manual added using phpmyadmin.

Something has been messed how to solve the issues.

Title: Re: No user assigned to db
Post by: Administrator on May 04, 2015, 10:01:34 PM

you would need to provide more info, from where are you creating database and with which option and what version of mysql do you have.

Title: Re: No user assigned to db
Post by: josejl on April 06, 2016, 06:43:45 PM

Hi,
I have the same problem. I have the mysql 5.6.x and when I create a new database in CWP and then I try to access via phpmyadmin I get this error "#1045 Cannot log in to the MySQL server" even if I create a new user in CWP the problem still happen.

Thank you

Update 04/06/2016

I found a solution for this. In my case what I do is:

Backup all databases and then :
Via ssh

mysql_upgrade -u "your mysql root user here" -p

When the upgrade process finish delete and create again the account in CWP. Login in the account go to phpmyadmin and login again and now is working.
I think something is messed up after the mysql upgrade to 5.6.x.

Sorry for my english.