Granting Privileges on the new database : Grant « Privilege « MySQL Tutorial






  1. MySQL Tutorial
  2. Privilege
  3. Grant

Syntax:

GRANT <privileges>
ON <database>
TO <user>
[IDENTIFIED BY <password>]
[WITH GRANT OPTION]

The items in square brackets are optional.









27.3.Grant
27.3.1.Granting Privileges on the new database
27.3.2.A user doesn't need a password if connecting from a certain machine
27.3.3.WITH GRANT OPTION condition allows the user to give others privileges to that database
27.3.4.GRANT ALL
27.3.5.Add localhost to mysql table for accessing sample_db
27.3.6.Grant Select and Update privilege to a user
27.3.7.Grant select, update privilege for a remote user
27.3.8.GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50
27.3.9.GRANT SELECT, UPDATE ON databaseName.*