hi,
When setting mysql_secure_installation script in percona xtraDB cluster 8.0.19, the script will ask me what security level I want, and I select medium, any way to change it back to low ?
some password we have is very simple and might not pass the security requirement, please suggest.
Hello DBA100,
Honestly, the best solution here is to simply make your passwords stronger, not weaker. But if you need to, you can simply change this by running ‘set global validate_password.policy=LOW’ which enforces an 8 character password with no complexity requirements.
“Honestly, the best solution here is to simply make your passwords stronger,”
yeah, I know, but our previous setting is low, so we better follow at this moment as all application has to change accordingly.
set global validate_password.policy=LOW’ which enforces an 8 character password with no complexity requirements.
but this is temporary global variable, we have to add it to my.cnf :
vaildate_password.policy=LOW
?
The advice is to change it temporarily so that you can use your low complexity password, but leave the default as MEDIUM for best practices. You can certainly make the change ‘stick’ by modifying /etc/my.cnf to keep it ‘LOW’.
yes. done already and it works ! seems hight is not good ? too complicated ?