What specific database privileges does WordPress need?

If your database is set up to deny remote connections (i.e. only applications on the same server can interact with the database) then there’s no danger in giving your WordPress user full access. As a matter of fact, most automated installation scripts used by web hosts grant full access to their WordPress user by default.

Keep in mind that your database “user” is not actually a site user … and unless you’re manually administering your database via phpMyAdmin, the login credentials will never be used by anything but WordPress.

That said, there’s no guarantee that future versions of WordPress won’t need the features you’re disabling. If you use your WordPress user to manually administer the database, you might need these features as well. My recommendation would be to grant full access to your WordPress user, but use a highly complex password for the user.

Related Posts:

  1. Setting up foreign keys in phpMyAdmin?
  2. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL Error #1133 – Can’t find any matching row in the user table
  4. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  5. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  6. How to create a foreign key in phpmyadmin
  7. importing a CSV into phpmyadmin
  8. Differences between utf8 and latin1
  9. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  10. MySQL Database User: Which Privileges are needed?
  11. What SQL Query to do a simple find and replace
  12. What are the recommended database permissions for WordPress?
  13. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  14. How to copy post titles to post slug in phpmyadmin
  15. Search and replace in post content
  16. How to do a MySQL dump from production site without using a search and replace script for local development?
  17. What is the most secure way to set up the MySQL user in WPMU?
  18. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  19. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  20. 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)
  21. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  22. Can’t find my wordpress DB in phpmyadmin
  23. Backing up and restoring multiple sites efficiently
  24. $wpdb to insert html form information
  25. Setting up WordPress Locally on WAMP for a new site (with one already)
  26. Getting Error Trying to Create Table
  27. Export Yoast Keywords from MySQL/phpMyAdmin
  28. Editing mysql tables/database with wordpress or other app/cms
  29. List users with the most posts in the last 30 days
  30. Export SQL query based on custom field?
  31. Mysql Server keeps crashing
  32. How to bulk delete a certain part of all wordpress posts
  33. When I add metadata, metavalue length is added in to the value in some cases
  34. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  35. Find locations of all featured images of draft posts via SQL
  36. SQL query to change custom field in WordPress database
  37. An SQL query to find orphaned image attachments and their meta
  38. MySQL Database User: Which Privileges are needed?
  39. Running WordPress from MySQL Cluster with HAPRoxy
  40. Global MySQL replacing of text patterns/matches
  41. cannot log in to the mysql server (wamp and wordpress)
  42. SQL command to export post_content from wp_posts using phpMyAdmin
  43. Need SQL query to find&replace image URL
  44. MySQL error 2006: mysql server has gone away
  45. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  46. How to get size of mysql database?
  47. SQL – Update multiple records in one query
  48. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  49. Generating a random & unique 8 character string using MySQL
  50. MySQL > Table doesn’t exist. But it does (or it should)
  51. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  52. MySQL delete multiple rows in one query conditions unique to each row
  53. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  54. CAST to DECIMAL in MySQL
  55. Failed to Connect to MySQL at localhost:3306 with user root
  56. Moving WordPress from MAMP to WAMP, can’t access pages
  57. How do you properly prepare a %LIKE% SQL statement?
  58. Any post install tips after installing WordPress 3.0.1?
  59. How to Create a Custom WordPress Install Package?
  60. Using source control with WordPress
  61. My WordPress site always displays a cached version of its homepage
  62. Multiple Domains and Subdomains Using Multisite Installation
  63. wpdb prepare syntax
  64. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  65. How to run this SQL query of wp_terms database
  66. On Install, which code sets the ‘home’ option?
  67. How to find if a post with custom_field == X exists?
  68. Proper way to work with wpdb to get user’s firstname
  69. Subdomain and subdirectories together in one installation
  70. How to change post format from Aside to Image for all posts?
  71. Inserting Hundreds of Thousands of Posts at Once
  72. wp_admin edit.php slow with lots of queries
  73. How to add and SQL query of posts only published
  74. Slow Mysql Queries
  75. Find duplicate posts with same slug and author
  76. writing inner join in wpdb
  77. How to get data from WordPress site sql file
  78. Unknown collation when I import a dump from an existing site into a development database?
  79. PHP script can’t connect to Database on port 3307
  80. WordPress with php5-fpm and nginx
  81. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  82. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  83. What should a WordPress developer know about MySQL? [closed]
  84. Copyright: Get first and last date of post type
  85. My custom sql query for getting a username giving me a warning and an error
  86. WordPress $wpdb no result
  87. Integrating Custom Database with WordPress
  88. Delete all users with Editor role and their content mysql
  89. edit_user_created_user hook – using to update Groups
  90. Mysql Error in querying form entries in Gravity Form plugin
  91. Add two or multiple functions in WordPress Post or Page
  92. Missing latest posts and options after DB migration via phpMyAdmin
  93. Saving custom term value to the database in new table
  94. MySQL errors after a WordPress clone
  95. Moving site made easier
  96. Multiple WordPress Pages
  97. Complicated MySQL Query
  98. problem with quotes on new post
  99. remove wordpress post links
  100. SQL get last entry of a specific gravity form

Leave a Comment