mysql 修改密码 开启远程访问权限

修改密码

update user set password=password('') where user='root';

FLUSH   PRIVILEGES;

远程访问权限：

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION;

 

FLUSH   PRIVILEGES;