mysql更改root密码及root远程登录

1.更改root密码

use mysql;
update user set password=password('petecc') where user='root';

2.root远程登录

1 update user set host='%' where host='localhost';
2 flush privileges;