Synchronize Sql Passwords

[dstana]

What is the procedure to synchronize passwords for MySQL users with WHM? When suspending accounts I keep getting errors that none of the passwords work. Running MariaDB10.3, seems related to the recent WHM issues with 10.3

These are the errors thrown when suspending accounts:

warn [suspendacct] GRANT statement “SET PASSWORD FOR ***********'@'***********' = '-28E5DC6343095DE40621B9F9F6160F702E779411';” failed:
info [suspendacct] Changing password for MySQL virtual user *********** as system user ***********...
info [suspendacct] Creating MySQL virtual user *********** for user ***********
warn [suspendacct] Error from MySQL query: (XID uj4cu3) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)

 

[cPRex]

Hey there! Have you tried changing the account password from WHM >> List Accounts to see if that gets everything back in sync?

 

[dstana]

Hey there! Have you tried changing the account password from WHM >> List Accounts to see if that gets everything back in sync?

This is a lot of work to go through EVERY account manually to change those. Also, 99% of these accounts have the original account passwords.

 

[cPRex]

Sorry about that - it wasn't clear to me that this is affecting every account on the machine.

If one password gets out of sync, that can happen, but for all the accounts to have this issue it sounds like something else is going on with the system. It might be better for us to take a look through the ticket system if you wanted to get one submitted. If you do go that route, please post the ticket number here so I can keep the community updated with the resolution.