Skip to content

Instantly share code, notes, and snippets.

@onnayokheng

onnayokheng/gist:9e8c70db01bad6926ef80dd3653db58d

Created January 1, 2020 02:50
Show Gist options
  • Save onnayokheng/9e8c70db01bad6926ef80dd3653db58d to your computer and use it in GitHub Desktop.
Save onnayokheng/9e8c70db01bad6926ef80dd3653db58d to your computer and use it in GitHub Desktop.
Download ZIP
Set global variable for mysql 8
Raw
gistfile1.txt
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 'root'@'localhost' IDENTIFIED BY 'root';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment