Mega Code Archive

 

Categories / MySQL / User Permission

 

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