On a local server testing server not floating out in the wild you can grant everything and the kitchen sink to the user. However in a production environment …
WordPress only needs the following:
Note some plugins and database updates may also require the following:
It is a good to follow a principle of Least Privilege wherever possible.
You can configure this in the phpMyAdmin User accounts section under Global privileges as shown here:
