User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. The following GRANT statement grants privileges to a user account named ethan
GRANT SELECT, INSERT
ON databaseName.tableName
TO ethan@localhost
IDENTIFIED BY 'pw1';