mysql with password policy

[eldzee]

Hi there,

we encountered a problem on fresh install whm/cpanel 84.0.18 with remote database mysql 5.7 all default configuration.
apparently the mysql server added password policy check

after all installation succeded and the remote mysql set
we tried to add new user: [Moderator Notice: This content was removed. Please avoid including server-specific information in the thread]
the user created successfully without any error in whm.
then we tried to login on that user and opened the phpmyadmin, then got error user 'example@<host>' does not exists

if we change the cpanel account password from whm into more complex password, then the database user get updated/created successfully, and phpmyadmin can be accessed without any error

then if we tried to change the cpanel account password back to the original it'll show these error message on the mysql side, but whm says the password change succeed

Password Modification
[Moderator Notice: This content was removed. Please avoid including server-specific information in the thread]


The following service passwords were changed: system , ftp , mail , MySQL.


our default mysql configuration has these password requirement:

[Moderator Notice: This content was removed. Please avoid including server-specific information in the thread]

 

[SamuelM]

Hello,

Thank you for contacting cPanel!

Based on your description, it sounds as though the password requirements for MySQL are stricter than those of cPanel. phpMyAdmin is accessed with the database user associated with the cPanel account, which has the same password as the cPanel account.

Please refer to the Password Validation Plugin for MySQL documentation on the following page:

MySQL :: MySQL 5.7 Reference Manual :: 6.4.3.2 Password Validation Plugin Options and Variables

dev.mysql.com

You might want to try disabling the Password Validation Plugin in your troubleshooting to isolate that as the issue, and then adjust the password strength requirements to allow the password you want to use. I would recommend you choose a stronger password if possible, as you mentioned that at one point you changed the user's password and were then able to access phpMyAdmin with no issues.

Please let us know if you have any questions.

Best regards,