mysql放行指定ip或所有ip访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'x.x.x.x' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;