设置密码:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '111111';
设置远程连接:
1)use mysql; 进入mysql数据库
(2)select host,user,password from user; 查询数据库的用户信息
(3)update user set host='%' where host='localhost'; 将上表中root的访问主机改为所有
(4)flush privileges; 刷新权限
(5)exit; 退出mysql