Mega Code Archive

 

Categories / MySQL / User Permission

 

The following GRANT statement grants privileges to a user account named ethan

GRANT SELECT, INSERT ON databaseName.tableName TO ethan@localhost IDENTIFIED BY 'pw1';