SOLVED phpMyAdmin login issue

[greektranslator]

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.

 

[ZenHostingTravis]

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.

 

[greektranslator]

Thanks, got it. For some reason the default had changed.

 

[cPRex]

I'm glad you were able to get both those issues resolved!

 

[ModServ]

@cPRex I've this issue happened to me 2 days ago and my setting is on

Root, Account-Owner, and cPanel User default

 

[cPRex]

@ModServ - have you tried changing the password for the user to see if that will also resolve your issue? If not, do you see anything inside /usr/local/cpanel/logs/error_log that may give you more details about the root of the problem?

 

[ModServ]

Actually that fixed it, you know the reason behind that?

 

[cPRex]

@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]

@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]

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:

WHM API 1 Functions - passwd - Developer Documentation - cPanel Documentation

documentation.cpanel.net