GRANT ALL ON database_name.* TO user_name@'ip_address' IDENTIFIED BY 'user_password'; Copy
GRANT ALL ON dbname.* TO foo@'10.8.0.5' IDENTIFIED BY 'my_passwd'; Copy