Skip to content

Instantly share code, notes, and snippets.

@thangtv611
Created July 13, 2021 10:08
Show Gist options
  • Save thangtv611/06c97ae28e5b348a9a30b0dfac82d317 to your computer and use it in GitHub Desktop.
Save thangtv611/06c97ae28e5b348a9a30b0dfac82d317 to your computer and use it in GitHub Desktop.

MYSQL

use native password

SET GLOBAL validate_password.LENGTH = 4;
SET GLOBAL validate_password.policy = 0;
SET GLOBAL validate_password.mixed_case_count = 0;
SET GLOBAL validate_password.number_count = 0;
SET GLOBAL validate_password.special_char_count = 0;
SET GLOBAL validate_password.check_user_name = 0;
ALTER USER 'user'@'localhost' IDENTIFIED BY 'pass';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment