Title: WordPress MySQL permissions
Last modified: August 19, 2016

---

# WordPress MySQL permissions

 *  [jamiesonteo](https://wordpress.org/support/users/jamiesonteo/)
 * (@jamiesonteo)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/wordpress-mysql-permissions/)
 * Hi folks,
 *  Can’t seem to find any article on the proper privileges for the wordpress mysql
   user. I can see from the doc it says “Grant All” privileges but surely this is
   not safe right? What are the exact rights that are is needed from WP to function
   without granting unnecessary privileges?
 * Thanks

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [whooami](https://wordpress.org/support/users/whooami/)
 * (@whooami)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/wordpress-mysql-permissions/#post-789183)
 * INSERT statements
    UPDATE statements DELETE statements CREATE tables DROP tables
 * — and probably an ALTER as well.
 *  [NC@WP](https://wordpress.org/support/users/ncwp/)
 * (@ncwp)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/wordpress-mysql-permissions/#post-789207)
 * GRANT ALL is necessary. The need to have SELECT, INSERT, UPDATE, and DELETE privileges
   is obvious; that’s how WordPress displays, stores, and manages content and settings.
   ALTER privilege is critical for upgrades (sometimes, new versions of WordPress
   and/or plugins need to change table structure). CREATE TABLE privilege is required
   for initial install of both WordPress and plugins that maintain their own data
   tables. DROP TABLE privilege is needed for plugins to uninstall themselves completely.
 *  [nicka](https://wordpress.org/support/users/nicka/)
 * (@nicka)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/wordpress-mysql-permissions/#post-789535)
 * Just came across this thread.
    im installing wp on fasthosts and according to
   their documentation i cannot grant ALL permissions. Are the following that they
   do allow sufficient?
 * >  Using the SSH command-line, you can grant the following permissions to MySQL
   > database users on our shared hosting platform:
   >  ALTER CREATE CREATE TEMPORARY
   > TABLES DELETE DROP INDEX INSERT LOCK TABLES SELECT UPDATE
   > The permissions that you cannot grant are:
   >  ALL FILE PROCESS RELOAD SHOW DATABASES
 * Thanks

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress MySQL permissions’ is closed to new replies.

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 3 replies
 * 4 participants
 * Last reply from: [nicka](https://wordpress.org/support/users/nicka/)
 * Last activity: [17 years, 4 months ago](https://wordpress.org/support/topic/wordpress-mysql-permissions/#post-789535)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics