Privileges to MySQL using Drupal

This is the privileges to MySQL database when using Drupal.

  1. SELECT
  2. INSERT
  3. UPDATE
  4. DELETE
  5. CREATE
  6. DROP
  7. INDEX
  8. ALTER


GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON databasename.* TO 'username'@'localhost' IDENTIFIED BY 'password';

Source: http://drupal.org/getting-started/6/install/create-database

Knowledge keywords: