Drupal MySQL database permissions
Submitted by erichagstrom on Sun, 03/02/2008 - 9:09am.
SELECT
INSERT
UPDATE
DELETE
CREATE
DROP
INDEX
ALTER
CREATE TEMPORARY TABLES
LOCK TABLES
Just a quicky post. I use drupal for a number of sites, and always have to lookup the database permissions required. Here they are nicely summarized. Essentially what I do is create a new user for each site that I am going to create. That new user has exclusive permissions to a new schema that I create for the site. Then I grant the following access rights to the database:
Happy Drupal-ing!
6.x works with less
According to the INSTALL.mysql.txt shipping with Drupal 6.8 you just need SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX and ALTER (no CREATE TEMPORARY TABLES and LOCK TABLES)
ludovicof
Post new comment