mysql新建用户，并navicat成功连接

1. 首次安装的mysql，执行mysql -u root进入mysql
2. 修改加密规则：ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
3. 更新用户密码：ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
4. 新建用户并修改加密规则和修改密码：CREATE USER 'john'@'localhost'  IDENTIFIED BY '123456';