Hot answers tagged mysql
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.
The second one is revision. It means the changes that you made, but didn't save. Wordpress saves that as revision post. There might be more than one revision post if you make more changes without updating the post. You don't need to worry about that. It's all in background and won't affect you in any way.
WordPress absolutely does need "DELETE", otherwise it has no way to delete posts or tags or options rows or anything else. The "DROP" command is sometimes used during upgrades, although it's been a long time. The last time I think it was used was during the WordPress 2.3 update, which removed the assorted categories tables in favor of the new taxonomy ...
If you remove revisions, your blog is going to be identical for the user. Only in the backend, you won't have access anymore to your post history. You can also use plugins like https://wordpress.org/plugins/wp-optimize/ to do that. Ref: http://codex.wordpress.org/Post_Types#Revision
Don't change the Post ID. Wordpress uses serialized data, and id's have deep linking within the database.
Wordpress doesn't work this way. If you want to work with a framework like Wordpress, you should obey its rules! Of course you can add a database record like this, but it is a really bad approach. Try some plugins for creating and saving forms in Wordpress like Ninja Forms or Quform. You can even do it yourself, but its not recommended for Wordpress ...
Only top voted, non community-wiki answers of a minimum length are eligible