Add localhost to mysql table for accessing sample_db : Grant « Privilege « MySQL Tutorial






  1. MySQL Tutorial
  2. Privilege
  3. Grant
mysql>
mysql>
INSERT INTO mysql VALUES('localhost','sample_db','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
mysql>








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.*