User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. Adding Users to Database
GRANT SELECT, UPDATE (FieldName1, FieldName2, FieldName3)
ON databaseName.tableName
TO 'myuserName'@'localhost' IDENTIFIED BY 'myPassword'
WITH MAX_CONNECTIONS_PER_HOUR 25;