mysql with password policy

eldzee

Registered
Dec 19, 2019
1
0
0
Earth
cPanel Access Level
DataCenter Provider
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 '[email protected]<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]
 
Last edited by a moderator:

SamuelM

Technical Analyst Team Lead
Nov 20, 2019
196
39
103
USA
cPanel Access Level
Root Administrator
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:


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,