安装mysql文章,实践有效:https://blog.csdn.net/ncdx111/article/details/79818304
使用初始密码登录mysql服务
mysql -u root -p
更新密码
alter user 'root'@'localhost' identified by 'root';
flush privileges;
开启远程连接权限
update user set host='%' where user='root';
flush privileges;
或者
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;其中%可以替换成指定主机ip,identified by后跟密码
flush privileges;
启动mysql service mysqld start
关闭mysql service mysqld stop