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?
GRANT SELECT ON database.* TO user@'localhost';
Plugins etc can though call any statement they want so you would have to thoroughly test everything you install if you restrict privileges.