1. use mysql;
    2. select user, host from user;
    3. update user host = '%' where user = 'ljy'
    4. # 更改加密方式
    5. mysql> ALTER USER 'ljy'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
    6. # 更改密码:该例子中 123456为新密码
    7. mysql> ALTER USER 'ljy'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
    8. # 刷新:
    9. mysql> FLUSH PRIVILEGES;