MySQL Database User: Which Privileges are needed?

The others are not needed as you point out.

Btw, what you could do is, conditionally set the user/pass based on the requested page. As in unprivileged with select/insert/update/delete for normal usage, and privileged with definition/index related stuff in addition when visiting the upgrade page.

Related Posts:

  1. MySQL Database User: Which Privileges are needed?
  2. creating new field on mysql
  3. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  4. WPCLI search and replace in a particlar site dir effect another site-dir
  5. Merging development site with live site
  6. how to encyrpt DB_PASSWORD in wp-config
  7. SQL query to set posts in bulk based on the post content
  8. Query Column of Specific ID from Database Table
  9. How can I detect right db type?
  10. How to create more than one new wpdb object?
  11. Moving WordPress site to new domain – database import [duplicate]
  12. How to connect and insert data in database of wordpress?
  13. Buddypress avatar image in database [closed]
  14. Changing order of db results when encoding to JSON
  15. Files on Localhost, Database on Server
  16. $wpdb->get_var – What value is returned when zero records are found?
  17. Remote database -> massive response time increase?
  18. Installing local to live WP into subdirectory
  19. Second ezSQL initialization for MSSQL
  20. Fetch a single row from a custom table for to a given ID
  21. Database create or redirect
  22. SymmetricDS in dev + prod workflow?
  23. Integrating Custom Database with WordPress
  24. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  25. Cloning blog to localhost via WAMP
  26. Only allow user to access a link once a year, based on their joining date
  27. Counting post and changing roles in mysql database. Query not code
  28. MSQL database wp_postmeta has meta key tve_revision
  29. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  30. Link multiple user databases together?
  31. DB prefix not updating
  32. Recovery – Restore Database after moving folder location locally
  33. Replacing javascript link in WordPress database without getting mysql syntax errors
  34. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  35. What is my error trying to create a new table in the database?
  36. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  37. Set a cron job to delete a specific database table table every midnight
  38. How to edit custom table data in frontend
  39. local wordpress broke after changing URL
  40. “BS_” rows in postmeta table
  41. how to access 2nd Mysqli Database from different server for wordpress
  42. Error establishing a database connection – WordPress setup, everything else is working
  43. How can I find user role in Mysql?
  44. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  45. How to import products in host instead of database on wordpress?
  46. I would like some help wth an SQL query to link posts with categories
  47. Where is the HTML-handler part in the wpdb class?
  48. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  49. Featured image from custom to WordPress database
  50. WordPress users table missing indexes
  51. WordPress Database Query works in phpMyAdmin but not in the code
  52. How to map data on CSV to web pages?
  53. How to create index (sql) to a meta_key?
  54. next comment id number wordpress
  55. Search and Replace in Windows XAMPP site
  56. Delete all users meta that named: user_avatar
  57. How can i syn wordpress user table with a stand-alone php script?
  58. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  59. insert data from a form:: Warning Empty query mysqli::query()
  60. How can I get $wpdb to show MySQL warnings?
  61. mySQL database size large, but tables size less
  62. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  63. spambot registering without providing email or password, bypassing registration process
  64. After renaming MySQL database, I can no longer access my Blog page
  65. How To connect to the same WordPress database with different database user
  66. Possible to restore wordpress database from mysql56 and sqlite files?
  67. WordPress Database Posts Table query
  68. Correct permissions for SQLite database
  69. Hang Up Followed By Can’t select database
  70. How to extract some part of WordPress full source code
  71. Mysql Queries per Visit – Crazy High
  72. Missing latest posts and options after DB migration via phpMyAdmin
  73. One WP Database outside localhost and two connections
  74. Check if a database is well installed
  75. Create a new table on the database and save parameters from a contact form
  76. live site do not update after importing sql database
  77. Why is converting my database to UTF-8 truncating entries?
  78. Widgets with *internal* links do not display after database migration
  79. using same mysql user with many databases
  80. How do i get value from wp_postmeta?
  81. Get id from database
  82. “MySQL server has gone away” since update to 3.8
  83. Why are my WordPress post queries so slow?
  84. featured image not showing up with mysql_connect
  85. Share WordPress Database
  86. Import Excel (or csv) Table with user-data as subscribers to wordpress
  87. Print output of Table Creation
  88. How to back-up a database on IIS
  89. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  90. export individual posts to text files or a single csv file
  91. SQL query : Select a thumbnail for a media
  92. Importing Concrete5 content to WordPress
  93. Custom wordpress SQL statement for a website
  94. why you don’t Implement PDO for access every thing to database
  95. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  96. WordPress database connection failed, while mysql client is working [closed]
  97. How to find fresh (last modified) and sql backup?
  98. Uploading to WordPress Database
  99. Have WordPress Use a Different Database for users
  100. How to generate PDF dynamically based on values from the database in WordPress