Delete all users with Editor role and their content mysql

It’s a three step process.

  1. First, get a list of Editors using WP_User_Query.

  2. Get a list of each user’s posts using get_posts and delete them using wp_delete_post.

  3. Lastly, delete the user itself using wp_delete_user.

Related Posts:

  1. Automatically delete inactive users after 2 months
  2. Delete all subscribers from wp_users and wp_usermeta a few thousand at a time
  3. ‘username_exists’ still returns an ID even after deleting record from the database?
  4. How can I add a user through SQL?
  5. importing users where password is provided as md5 + much metadata
  6. Search multiple meta keys at once
  7. Return ID of authors who have at least one post
  8. How to delete users with no order history through phpmyadmin sql?
  9. wp_insert_user is not working for me?
  10. Set Display Name to first and last name (phpmyadmin SQL Query)
  11. Add user data to table when user is created?
  12. Bulk create clean user_nicename from user_email with SQL function
  13. C# user_nicename and Display name blank
  14. How do I transfer user passwords from one WordPress site to another?
  15. I am getting mysql_real_escape_string() function error while adding user?
  16. MySQL query to mass change role of users
  17. WordPress SQL Issue not returning correct reselts
  18. create new users in db starting at what ID?
  19. Delete Users without a First and Last Name
  20. How do I change the user via SQL?
  21. is_user_logged_in() not working after domain change
  22. MySQL query to list users who never signed in
  23. How to log in to phpMyAdmin with WAMP, what is the username and password?
  24. Setting up foreign keys in phpMyAdmin?
  25. phpMyAdmin: secret passphrase?
  26. Forbidden :You don’t have permission to access /phpmyadmin on this server
  27. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  28. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  29. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  30. MySQL Error #1133 – Can’t find any matching row in the user table
  31. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  32. How to create a foreign key in phpmyadmin
  33. importing a CSV into phpmyadmin
  34. MySQL: Can’t create table (errno: 150)
  35. MySQL: How to reset or change the MySQL root password?
  36. MySQL Daemon Failed to Start – centos 6
  37. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  38. Moving WordPress from MAMP to WAMP, can’t access pages
  39. Moving WordPress from MAMP to WAMP, can’t access pages
  40. If the current user is an administrator or editor
  41. Editor can create any new user except administrator
  42. How do I add a field on the Users profile? For example, country, age etc
  43. How do I display logged-in username IF logged-in?
  44. How to allow an user role to create a new user under a role which lower than his level only?
  45. user_login vs. user_nicename
  46. How to programatically change username (user_login)?
  47. Change the Author Slug from Username to Nickname
  48. Remove Ability for Other Users to View Administrator in User List?
  49. Difference between update_user_meta and update_user_option
  50. Make display name unique
  51. Make WooCommerce pages accessible for logged in users only
  52. Find out if logged in user is not subscriber
  53. WordPress usermeta scaling for thousands of users
  54. How to get WordPress Username in Array format
  55. Display user registration date
  56. Get multiple roles with get_users
  57. get_user_meta() doesn’t include user email?
  58. Confirmation required on email change
  59. How to Merge Two Authors Into One?
  60. Whats the best way to share user data across multiple WordPress websites?
  61. get_current_user_id() returns 0?
  62. How to get userid at wp_logout action hook?
  63. Groups of capabilities: users with multiple roles?
  64. Is there a way to merge two users?
  65. User-edit role setting distinct from wp_capabilities? [closed]
  66. List users by last name in WP_User_Query
  67. What’s the difference between the capability remove_users and delete_users?
  68. How to restrict access to uploaded files?
  69. How to change user_login with wp-cli?
  70. Email user when password is reset by admin
  71. Replacing the WordPress password validation
  72. Ban a user and end their session
  73. Allowing users to edit only their page and nobody else’s
  74. How can 2 blogs share the same users
  75. alphabetically order role drop-down selection in dashboard
  76. WordPress auto login after registration not working
  77. Change the author slug from nickname to ID
  78. Execute a function when admin changes the user role
  79. How to let contributors to create a new revision(draft) editing their published posts
  80. how to use joomla password format in wordpress?
  81. How to do get_users() with multiple meta_keys
  82. Disallowing Users of a Custom Role from Deleting or Adding Administrators?
  83. What the user_status column?
  84. How to limit users to one comment per post
  85. Different back-end language for different users?
  86. Hide Admin Menu for Specific User ID who has administrator Role
  87. Migrating WordPress users into Disqus
  88. Problem with Hebrew characters in username
  89. Is there an upper limit for users in WP?
  90. How to display the status of users (online – offline) in archive.php
  91. Remove email verification when new user register
  92. How to change user`s avatar?
  93. How to set up User email verification after Signup?
  94. Allow up to 5 Concurrent Login Sessions
  95. How to let user set password on registration
  96. How to hide media uploads by other users in the Media menu?
  97. Show admin bar only for some USERS roles
  98. How to display custom user meta from registration in backend?
  99. Allowing an email as the username?
  100. How to work around “that email address has already been used” error?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)