mysql如何授权给指定的ip账号进行登录

GRANT ALL PRIVILEGES ON *.* TO 'aitang'@'192.168.100.142' IDENTIFIED BY '123' WITH GRANT OPTION;
FLUSH PRIVILEGES;