Mysql-tips

decrease security

SET GLOBAL validate_password_length=4; 
SET GLOBAL validate_password_policy=LOW;

update user password

UPDATE mysql.user  SET authentication_string = PASSWORD('pass'), password_expired = 'N' WHERE User = 'root' AND Host = 'localhost';

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED WITH mysql_native_password by 'pass';

grant option privilege

GRANT GRANT OPTION ON *.* TO 'user'@'%';

replace wrong datetime in data file

for all

sed -i -- 's/0000-00-00/2018-01-01/g' *.data  

for one

sed -i -- 's/0000-00-00/2018-01-01/g' save_file.data