The famous 5 minutes installation for WordPress state that:
Create a database for WordPress on your web server, as well as a MySQL user who has all privileges for accessing and modifying it
Most installation instruction for WordPress on the web state that you can GRANT ALL PRIVILEGES to that user.
Q. What are the least required access rights or privileges that I should grant to this user for WordPress to function properly?
A. You can grant the following permissions to a MySQL user :
- ALTER
- CREATE
- CREATE TEMPORARY TABLES
- DELETE
- DROP
- INDEX
- INSERT
- LOCK TABLES
- SELECT
- UPDATE