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';
The official documentation says to give the user all privs. Others suggest that you can restrict it to
Plugins etc can though call any statement they want so you would have to thoroughly test everything you install if you restrict privileges.