Mega Code Archive

 

Categories / MySQL / User Permission

 

Create a user named marti on localhost with a password of tick3t, who has ALL privileges on the duck_sales table, and then

GRANT ALL ON duckwear.duck_sales TO marti@localhost IDENTIFIED BY "tick3t"; REVOKE DELETE, DROP, ALTER ON duckwear.duck_sales FROM marti@localhost; SHOW GRANTS FOR marti@localhost;