SOLVED phpMyAdmin login issue

greektranslator

Well-Known Member
Jun 5, 2011
88
2
58
Greece
cPanel Access Level
Root Administrator
Edit: fixed by changing again password via WHM and syncing MySQL password
I log in to the domain Cpanel just fine. I click on phpMyAdmin and then I get:

Login without a password is forbidden by configuration (see AllowNoPassword)
mysqli_connect(): (28000/1045): Access denied for user 'translat'@'localhost' (using password: YES)
mysqli_connect(): (28000/1045): Access denied for user 'translat'@'localhost' (using password: YES)
Undefined index: auth_type
I check the username and pass appearing in that error page. It is the same as the one to log in to Cpanel.

This one still an issue:
Also, when I list accounts from WHM, I see no CPanel icon in order to log in to each account's Cpanel.
 
Last edited:

ZenHostingTravis

Well-Known Member
PartnerNOC
May 22, 2020
213
68
28
Australia
cPanel Access Level
Root Administrator
Hi @greektranslator,

In regards to your second question, if you're the administrator of your system, in Tweak Settings, you have to allow root (assuming you have root access) to be able to access a cPanel user account.

This is the setting:
Accounts that can access a cPanel user account.

Hope that helps.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
3,236
404
243
cPanel Access Level
Root Administrator
@ModServ - I'm glad that's all it was. When this happens, it just indicates that the cPanel user password and PHPMyAdmin access for that particular user was out of sync. It's hard to say exactly why this happens, but one option would be the MySQL password getting reset from command line, or changes to the server's hostname that didn't properly update all the grants. The good thing, is that in most cases a simple password reset like what you performed does take care of the issue.
 

ModServ

Well-Known Member
Oct 17, 2006
337
5
168
Egypt
cPanel Access Level
Root Administrator
@ModServ - I'm glad that's all it was. When this happens, it just indicates that the cPanel user password and PHPMyAdmin access for that particular user was out of sync. It's hard to say exactly why this happens, but one option would be the MySQL password getting reset from command line, or changes to the server's hostname that didn't properly update all the grants. The good thing, is that in most cases a simple password reset like what you performed does take care of the issue.
I've something in mind, I used a bash script to batch change password for all websites, maybe because of that? and if so, how can I change password for all accounts at one time? I've more than 200 websites on the same server.
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
3,236
404
243
cPanel Access Level
Root Administrator
It's possible that is related to the issue.

I think it's key to make the distinction between *you* resetting the password for them as the admin, or the user resetting their own password the next time they access their cPanel account. For the latter option, we have the WHM >> Force Password Change tool, which will allow you to force all users to reset their password the next time they try and access their cPanel account, so you don't have to be involved in that process at all.

If you want to manually change the cPanel user password as the server admin for multiple accounts, I'd recommend looking into creating a custom script with this API: