mysql 開啟遠端登陸及修改密碼

mysql -uroot -p;

use mysql;

update user set host = '%' where user = 'root';

flush privileges;

grant all privileges on *.* to 'root'@'%' identified by 'dahua' with grant option;

SET PASSWORD FOR 'root'@'%' = PASSWORD('');

SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('');

flush privileges;