What are the recommended database permissions for WordPress?

If you did want to lock things down…. a normal wordpress site will usually only require the database user to have SELECT, INSERT, UPDATE and DELETE.

If you want to use the automatic update feature it will also require CREATE and ALTER.

Some plugins may require other permissions but most won’t.

Related Posts:

  1. How can I prevent SQL injection in PHP?
  2. MySQL Database User: Which Privileges are needed?
  3. What specific database privileges does WordPress need?
  4. What is the most secure way to set up the MySQL user in WPMU?
  5. Changing Table Prefix for an Existing WordPresss Site
  6. Problem with admin login after deployment
  7. MySQL Database User: Which Privileges are needed?
  8. How can I show user’s privileges in MySQL?
  9. Changing host permissions for MySQL users
  10. How to find source of these strange SQL queries?
  11. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  12. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  13. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  14. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  15. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  16. When to use SELECT … FOR UPDATE?
  17. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  18. Column ‘user_id’ in field list is ambiguous
  19. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  20. Search for all occurrences of a string in a mysql database
  21. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  22. How to convert a string to date in MySQL?
  23. MySQL COUNT DISTINCT
  24. How to update a record using sequelize for node?
  25. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  26. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  27. Convert MySQL to SQlite [closed]
  28. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  29. Convert partially non-numeric text into number in MySQL query
  30. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  31. MySQL: What’s the difference between float and double?
  32. How can I search (case-insensitive) in a column using LIKE wildcard?
  33. MySQL Select Multiple VALUES
  34. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  35. How to unblock with mysqladmin flush hosts
  36. Node.js MySQL – Error: connect ECONNREFUSED
  37. Solution to “subquery returns more than 1 row” error
  38. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  39. How To have Dynamic SQL in MySQL Stored Procedure
  40. MySQL – UPDATE query with LIMIT
  41. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  42. What SQL Query to do a simple find and replace
  43. Alternative to mysql_real_escape_string
  44. Increment value (value = value+1) of $wpdb->update
  45. How can I debug my database connection for unit testing?
  46. Same option_id=0 for 2 options in wp_options?
  47. How to let a user choose an authors and save it to the database?
  48. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  49. MySQL LIKE not working
  50. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  51. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  52. Securing a multi-user permission structure
  53. Join new table with SQL query
  54. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  55. MySQL crashed because of the large number of requests
  56. Why doesn’t this code add a table to my database?
  57. SQL database export-import
  58. Can Someone Help Me Fix This WordPress Missing Argument Error?
  59. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  60. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  61. SQL Database, repeated tables?
  62. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  63. Code to remove authors with no posts connected to them
  64. SQL Query in WordPress – Getting Impossible WHERE error
  65. SQL syntax error when getting data for a url
  66. WordPress create database not working
  67. Import CSV to MySQL, with custom registration field information
  68. database optimization and server errors
  69. Setting up WordPress Locally on WAMP for a new site (with one already)
  70. Calling mysql_query() on another database, assumes WordPress using that database
  71. WordPress VIP realpath Alternative?
  72. querying user bookmarks from a large number of bookmarks
  73. Pull post name from value of a specific meta key
  74. PHP variables in mysql query
  75. Export SQL query based on custom field?
  76. How to fix the amount of comments displayed for each post?
  77. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  78. Lock wait timeout exceeded; try restarting transaction
  79. How to simulate web traffic to test performance of a website
  80. SQL query to change custom field in WordPress database
  81. SQL. Select category descendants
  82. MySQL Actibity without any active visitors via Google Analytics
  83. How to configure WordPress Database for CentOS 7
  84. Why is local wordpress install calling live site executions?
  85. Display MySQL as part of a Page
  86. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  87. Use custom query if main search query returns zero results in wordpress
  88. WP Meta Query – mixed AND / OR query doesn’t work
  89. Second completely independent and disposable WordPress installation in subdirectory?
  90. get_results suddenly not working on a single table
  91. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  92. Query sql for truncate post_content in wp_posts table
  93. Problem with permissions in wp-content/plugins
  94. Foreach only outputs if id is 0
  95. Using queries in and i see 7000+queries?
  96. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database

Leave a Comment