Adding Users to Database : SQL Privilege « User Permission « SQL / MySQL

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;

Related examples in the same category

1.	Check the privilege
2.	Grant select and update on two column in a table
3.	Grant with user name and password
4.	Grant select and update to all tables
5.	Grant select and update with time limitation
6.	Check out the privilege for a user
7.	List the host, DB, table name and column name for a user
8.	Read the user table
9.	Read host, db, user, table name and table privilege from privilege table
10.	Read column privilege