MySQL Tutorial » Privilege » Remote User

[VelMurugan]

Give a non-local user permissions on the database for use with remote clients

GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@192.168.0.2
IDENTIFIED BY 'newpassword';

Now a user on the machine '192.168.0.2' can connect to the database.

Designate an IP or host address from which the user can connect

GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@192.168.0.2
IDENTIFIED BY 'newpassword';

To allow a user to connect from anywhere you would use a wildcard '%'

GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@'%'
IDENTIFIED BY 'newpassword';

Source : java2s