Home / server / Questions / 392902
Accepted
h00j
Asked: 2012-05-27 04:06:01 +0800 CST

What privileges does a MySQL User need for Wordpress?

  • 772

I need to create a new MySQL user to manage my wordpress site. What privellages are needed for wordpress?

I assume INSERT is also needed and maybe DROP?

Example

GRANT SELECT ON database.* TO user@'localhost';
mysql debian wordpress

1 Answers

  1. Best Answer

    The official documentation says to give the user all privs. Others suggest that you can restrict it to

    • SELECT
    • INSERT
    • UPDATE
    • DELETE
    • CREATE
    • DROP
    • ALTER
    • INDEX

    Plugins etc can though call any statement they want so you would have to thoroughly test everything you install if you restrict privileges.

    • 9