MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements !!
Change mysql root password on Centos7
First you login with mysql -u root -p and check the current policy rules by: # SHOW VARIABLES LIKE ‘validate_password%’; +————————————–+——–+ | Variable_name | Value | +————————————–+——–+ | validate_password_dictionary_file | | | validate_password_length | 5 | | validate_password_mixed_case_count | 1 | | validate_password_number_count | 1 | | validate_password_policy | MEDIUM | | validate_password_special_char_count | 1 […]
dit the initial root password on install can be found by running grep ‘temporary password’ /var/log/mysqld.log http://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html systemd is now used to look after mySQL instead of mysqld_safe (which is why you get the -bash: mysqld_safe: command not found error – it’s not installed) The user table structure has changed. So to reset the root […]