Wrong username/password. Access denied.

jsnape

Well-Known Member
Mar 11, 2002
174
0
316
I submitted a ticket on this on August 26 (3 days ago) and it's still sitting there unaknowledged. So lets see if there is any better luck here:

Problem: Getting &Wrong username/password. Access denied.& when trying to log into phpmyadmin on any account on the server.


This appears to have happened just after udat
ing to WHM 4.9.0 Cpanel 4.9.0-60 RedHat 7.2.

Steps to Reproduce:
1.Log in to any end user control panel
2.Click on PhpMyAdmin


Any ideas??
I've already tried resetting MYSQL password which appeared to fix it for about 10 seconds but it is back.
 

Radio_Head

Well-Known Member
Verifed Vendor
Feb 15, 2002
2,048
1
343
same problem here
 

portman

Well-Known Member
May 23, 2002
70
0
306
I have seen this when we go into a users account before they have created users and databases. PHPmyAdmin will generate the error you list prior to these being created for a particular account.
 

jsnape

Well-Known Member
Mar 11, 2002
174
0
316
It happens then too, but this is happening on all accounts on the server which existed before the install of the latest build. Including accounts with up to 5 existing datbases. It's not very comforting that the ticket is still not responded to after over a week. Is this also normal (ignoring help tickets)?
 

Shi

Member
Feb 19, 2002
18
0
301
wrong username.password

hm.
I just updated tand everything is great but now phpmyadmin is giving the same errors that were posted in this thread.

How was this one resolved?
Thanks
 

jsnape

Well-Known Member
Mar 11, 2002
174
0
316
If you are logged in to their CPanel using your password instead of theirs it will give the error.
 

Shi

Member
Feb 19, 2002
18
0
301
nahh
this is for every account on the server - they are logged into their cpanels with their own username/password and it gives that error :/
 

booger

Registered
Apr 8, 2003
1
0
151
Wondering the same thing. I am having this problem as well. I have searched and searched. Made sure I logged out and back in, no bookmarks, etc. Still nothing. I have also just upgraded to the latest 2.5.1.

cPanel.net Support Ticket Number:
 

Daniel Artes

Well-Known Member
Jun 21, 2003
50
0
156
USA - Baltimore
I have the same problem with the last versionof WHM, when i create a new ser and i try to login it says access denied, i have the correct passwor d and everything.... I tried everything and i don't know what to do.

cPanel.net Support Ticket Number:
 

Rhode

Member
Feb 10, 2003
15
0
151
Same problem, was working fine until I updated Cpanel
to 7.2.0-RELEASE, Build 22 today.

Welcome to phpMyAdmin 2.5.1
"Wrong username/password. Access denied".

Anyone know the fix yet?

cPanel.net Support Ticket Number:

cPanel.net Support Ticket Number:
 

Lamar

Well-Known Member
Jan 9, 2002
98
0
306
Is this something other than the update which runs every night? My servers have started doing this.

cPanel.net Support Ticket Number:
 

Lamar

Well-Known Member
Jan 9, 2002
98
0
306
Oh, and I am using the Stable build.
WHM 6.4.2
Cpanel 6.4.2-S75

cPanel.net Support Ticket Number:
 

Website Rob

Well-Known Member
Mar 23, 2002
1,501
1
318
Alberta, Canada
cPanel Access Level
Root Administrator
I do know that people who were having this 'login' problem had forgotten that you can only login into phpMyAdmin using the ID & PW of the account owner, for the phpMyAdmin you are trying to log into. Most were logged in using 'root' or 'reseller' PW which is no good.

I have never run into this 'login' problem, except for when the above also applied to me. :eek:

cPanel.net Support Ticket Number:
 

Mindlash

Well-Known Member
Jul 7, 2003
77
0
156
Seems to be an issue still, though not sure if Mine is directly related, as I can log into some client accounts fine, but others (most) I get a username/password error..

Thoughts?

cPanel.net Support Ticket Number:
 

verdon

Well-Known Member
Nov 1, 2003
946
18
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
 

comprock

Member
Nov 6, 2003
16
0
151
One Fix

The following did the trick for me. Just logout of cpanel and relogin before trying to access phpMyAdmin as an user.

http://faq.cpanel.net/show.cgi?qa=104700616405907

Rewritten here:
Make sure root pass is in /root/.my.cnf

This is usually the first root pass the box was given once cpanel is installed.

If it still does not work, you will need to reset the mysqld root pass.

First, stop the mysqld, usually /etc/rc.d/init.d/mysql stop

Then stop chkservd to keep it from interfering with mysqld while you work on it
with /etc/rc.d/init.d/chkservd stop

Start up mysqld , but, without the grant tables,

mysqld --skip-grant-tables -u mysql &

Then change the pass..

mysql -u root mysql
UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
FLUSH PRIVILEGES;

Now you just killall -9 mysqld and start it up normally with it's safe_mysqld
script..
 

verdon

Well-Known Member
Nov 1, 2003
946
18
168
Northern Ontario, Canada
cPanel Access Level
Root Administrator
I did try this. I didn't think it had worked, then the next morning things were OK again. I know I had a cPanel update that night and had attributed the resolution to that, though perhaps it was this fix that had worked.

Thanks,