User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. The GRANT statement grants SELECT and UPDATE privileges on all tables in the test database
GRANT SELECT, UPDATE
ON test.*
TO 'user1'@'domain1.com' IDENTIFIED BY 'pw1';