Client Can't Access phpMyAdmin through cPanel

Jeff75

Well-Known Member
Apr 11, 2003
555
0
166
One of my clients changed their MySQL database password today and now it's not letting them into their database through phpMyAdmin in cPanel. I have tried accessing other accounts and can view their databases, it's just this one account thats having problems. I've also tried restarting MySQL and cPanel and it's still showing this:

Welcome to phpMyAdmin 2.5.2

Wrong username/password. Access denied.

Can somebody tell me how to fix this?

cPanel.net Support Ticket Number:
 

Jeff75

Well-Known Member
Apr 11, 2003
555
0
166
Does anybody have any idea how to fix this??? I've also tried resetting the mysql root password and it didn't help. My client really needs to access his database!!

cPanel.net Support Ticket Number:
 

Angel78

Well-Known Member
May 9, 2002
413
1
318
I had the same issue, i think i got it solved by changing the root password for mysql.

cPanel.net Support Ticket Number:
 

moogle

Well-Known Member
Apr 7, 2003
94
0
156
Same problem. Changing root pass did not work.

cPanel.net Support Ticket Number:
 

PeterDB

Registered
Mar 6, 2003
3
0
151
Use the Password Modification feature in Web Host Manager to "reset" the password for the account.
 

Jeff75

Well-Known Member
Apr 11, 2003
555
0
166
It turned out that the problem was because I was logging in with the root password. You need to use the client's password in order to access phpMyAdmin through cPanel, which I wasn't aware of until the cPanel tech pointed this out.
 

verdon

Well-Known Member
Nov 1, 2003
919
12
168
Northern Ontario, Canada
cPanel Access Level
Root Administrator
I'm experiencing the same sorts of things... last night, all was well, today, phpMyAdmin refuses accept the username:password being passed by cpanel when a user is logged in.

I've searched through the forums quite a bit, have tried the fix mentioned here as well as others, all to no avail.

I'm using;

WHM 8.5.4 cPanel 8.5.4-R72
RedHat 8.0 - WHM X v2.1.1
mysql (4.0.15-standard)
phpMyAdmin 2.5.2

I haven't installed anything or changed anything that I am aware of, from what was working fine for the last 2 weeks I've had this box.

I don't seem I'm the only one encountering this, though some of the posts I've read are quite old and apply to earlier versions of cpanel.

Is there a definitive fix?

Thanks,
verdon
 

andyf

Well-Known Member
Jan 7, 2002
249
0
316
UK
Anyone any success with what PeterDB suggests? Changing the account password using WHM can often resolve this.

For the sake of others, please feed back here if you resolve it.
 

andyf

Well-Known Member
Jan 7, 2002
249
0
316
UK
And can you access from the shell as the root user? (i.e. is your root pass working).

Also, double check the permissions on databases in /var/lib/mysql
 

verdon

Well-Known Member
Nov 1, 2003
919
12
168
Northern Ontario, Canada
cPanel Access Level
Root Administrator
Originally posted by goal
And can you access from the shell as the root user? (i.e. is your root pass working).

Also, double check the permissions on databases in /var/lib/mysql
I'm pretty sure I can as I used shell to reset the root mysql word, following another tip I found in another thread.

Permissions may be something though...

One of the things I tried was a complete update of my cp and mysql. Sometime during this process, permissions did get messed on my httpd.conf file. Perhaps this is the case on the databases too?

I'm running out of time tonight but will check those in the morning. What should the permisions be?

TIA, verdon