Grant with user name and password : SQL Privilege « User Permission « SQL / MySQL

Grant with user name and password

GRANT SELECT, UPDATE (columnName1, columnName2)
ON databaseName.tableName
TO 'userName'@'' IDENTIFIED BY 'password'
REQUIRE SUBJECT 'test client cert.'
  AND ISSUER 'Test C.A.';


Related examples in the same category

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