Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

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';