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.