Author Topic: No user assigned to db  (Read 8596 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
No user assigned to db
« 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.

Offline
*
Re: No user assigned to db
« Reply #1 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.
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: No user assigned to db
« Reply #2 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.
« Last Edit: April 06, 2016, 07:54:49 PM by josejl »