Friday, June 23, 2017

Generate Load on Linux server for testing

Generate Load on Linux server for testing (Here 1..8 means 8 core cpu which can be updated as per your requirement)

for i in {1..8}; do while : ; do : ; done & done



You can also type the same with below format (Numbers depends on CPU core)
for i in 1 2 3 4 ; do while : ; do : ; done & done


Kill the above process with below command

for i in {1..8}; do kill %$i; done

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements - Solved

If you are getting below error with mysql 5.7.18 while updating password & can't restart your mysql-server
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Solution -

Check validate password values with below command 

SHOW VARIABLES LIKE 'validate_password%';

Just set your Validate Password policy to LOW with below command


SET GLOBAL validate_password_policy=LOW; 

Now you can update the password. By default the value is MEDIUM & you can set the same to default once your work is complete


 If you want it permanently, You can simply disable the same with below setting in /etc/my.cnf
validate-password = off

Note- You need to restart mysql server to reflect any changes with my.cnf file