在centos7下安装运行后MySQL,就开始考虑远程链接centos下的MySQL,可以在windows下操做myql:
遇到了各种各样的报错问题:
关于登陆密码,先后报:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
后进行密码设计时报错
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
解决方案:
set global validate_password_policy=0;
set global validate_password_mixed_case_count=0;
set global validate_password_number_count=3;
set global validate_password_special_char_count=0;
set global validate_password_length=3;
set password=password('密码');
运行都ok后,就可以在windows下的MySQL的界面管理工具链接
注意:centos7 网络模式应采用桥接模式