Mega Code Archive

 

Categories / MySQL / User Permission

 

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;