MySQL Database User Privileges?

[Lance O.]

Which of the following are the minimum MySQL database user privileges required by ProcessWire?

ALTER

CREATE

CREATE ROUTINE

CREATE TEMPORARY TABLES

CREATE VIEW

DELETE

DROP

EXECUTE

INDEX

INSERT

LOCK TABLES

REFERENCES

SELECT

SHOW VIEW

TRIGGER

UPDATE

[ryan]

The DB configuration screen of the installer should tell you what are the minimum permissions PW needs to run. To the best of my knowledge, ProcessWire doesn't currently use trigger, show view, execute, create view or create routine, and possibly a couple of others. But that's not to say that it won't in the future or that 3rd party modules don't/won't ever use any of these. If there are any specific privileges that make you uncomfortable, you can always experiment by disabling them. But don't disable that the installer says are required. 

[Lance O.]

Thanks, Ryan.

Is this information on the install screen new to ProcessWire 2.9? If not, how could I have missed it? 

[ryan]

It's in kind of small text on the MySQL config screen: 

*Recommended permissions are select, insert, update, delete, create, alter, index, drop, create temporary tables, and lock tables.

[Hari KT]

Is there a way in PW to make use of mysql views?

[olivetree]

Hi

I am currently setup a new staging instance and I asked myself if there are changes to the db privileges needed for PW since the last answers in this thread.
MariaDB on my hosters site permits those privileges, but not all are neccessary  for PW and modules I guess:

• ALTER
• ALTER ROUTINE
• CREATE
• CREATE ROUTINE
• CREATE TEMPORARY TABLES
• CREATE VIEW
• DELETE
• DROP
• EVENT
• EXECUTE
• INDEX
• INSERT
• LOCK TABLES
• REFERENCES
• SELECT
• SHOW VIEW
• TRIGGER
• UPDATE

Any recommendations from your side? Many thanks

Edited 19 hours ago by olivetree
typo correction