Privilege MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Privilege
  4. 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';