mysql user connect privilege management

grant all privileges on *.* to 'root'@'%.your-domain' identified by 'password' with grant option;
grant all privileges on *.* to 'root'@'your-segment.%' identified by 'password' with grant option;
flush privileges;
show grants;
quit;

mysql -h host -u root -p