MySQL Database User Priveleges

wordpress

#1

Does a wordpress mysql user need any priveleges other than

SELECT
INSERT
UPDATE

?

Wanting to make sure all DB users listed in wp-config have only access needed and not the entire kitchen sink.


#2

At a bare minimum, you’ll also need DELETE.

That being said, full privileges are recommended to make automatic upgrades and plugin installation work properly. Using a MySQL user with limited privileges is likely to cause weird issues, I’m afraid. :confused:


#3

ah ok. one can dream i guess. thx