1、设置远程连接
grant all privileges on *.* to 'root'@'%' identified by '密码' with grant option;
flush privileges;
2、重新设置root密码
update user set password=PASSWORD('新密码') where user='root';
flush privileges;
1、设置远程连接
grant all privileges on *.* to 'root'@'%' identified by '密码' with grant option;
flush privileges;
2、重新设置root密码
update user set password=PASSWORD('新密码') where user='root';
flush privileges;