December 2016
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  

Categories

December 2016
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  

MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements !!

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 […]

Change mysql root password on Centos7

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 […]