Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

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.