1.修改root密码
ALTER USER 'root'@'%' IDENTIFIED BY 'yorktek888!@#$';
flush privileges;
2.设置可以远程连接
update user set host = '%' where user = 'root';
flush privileges;
登录
--root是登录用户名
mysql -uroot -p
1.修改root密码
ALTER USER 'root'@'%' IDENTIFIED BY 'yorktek888!@#$';
flush privileges;
2.设置可以远程连接
update user set host = '%' where user = 'root';
flush privileges;
登录
--root是登录用户名
mysql -uroot -p