安装了mysql,发现root账户突然无法远程访问了,网上查了,
mysql -u root -p
use mysql;
select User,Host from user
发现root的host是localhost,需要给他改成*,任意用户可以访问的
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678' WITH GRANT OPTION;
其中12345678是密码
但发现我的root账户密码是12345678太简单,报错了
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
还需要执行
SET GLOBAL validate_password_length=5;
SET GLOBAL validate_password_policy=0;
把需求的密码复杂级别调到最低
再执行
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678' WITH GRANT OPTION;
然后刷新权限就行了
flush privileges;
执行 select User,Host from user查看账户信息
发现多了一个root账户,host为*
可以了