mysql开启远程连接及修改root密码

开启远程连接 用户名open，密码是123456
mysql> grant all privileges on *.* to 'open'@'%' identified by '123456';  
mysql> flush privileges;


修改root密码，将root密码修改为123456
mysql> use mysql; 
mysql> desc user;
mysql> update user set Password = password('123456') where User='root';
mysql> flush privileges;