1.安装之后的密码
#启动MySQL
systemctl start mysqld
#启动成功后可以查看初始化密码随机生成的
cat /var/log/mysqld.log | grep password
2.安装后第一次登录要修改密码
#登录MySQL修改mysql用户密码
mysql -u root -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
会报:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements,这个错误。原因是不符合当前策略规范。必须先修改一个符合要求的含有特殊字符,大小写字母和数字的密码,然后修改当前密码策略:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Yss_yan1996';
mysql> set global validate_password.policy=0;
mysql> set global validate_password.length=1;
3.远程连接设置(报错:1130-host ... is not allowed to connect to this MySql server)
#远程设置
mysql> use mysql;
mysql> update user set host='%' where user='root';
#授权用户名的权限,赋予任何主机访问数据的权限
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
4.Navicat for MySQL连接报错( Client does not support authentication protocol )
#修改加密规则 (这行我没有写,不过貌似也可以)密码需要设置包含大小写字母符号和数字的格式,否则设置不会超成功
ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
#更新一下用户的密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
#刷新权限
FLUSH PRIVILEGES;
5.表名会区分大小写
程序已经部署,并且简单修改后未发现错误,以后再改这个bug