mysql修改密码忽略表明大小写及修改密码级别

1.表明忽略大小写

  lower_case_table_names=1

2.密码级别修改

   set global validate_password_policy=0;

    set global validate_password_length=1;

3.编码修改

character-set-server=utf8

collation-server=utf8_general_ci

4.修改用户密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

 flush privileges;