How can change 12000 user role into contributor by sql [duplicate]

Manually change 1 user to a contributor then view their wp_capabilities entry in wp_usermeta table.

Update the rest of the table to set wp_capabilities to this value for the 12,000 users.

Related Posts:

  1. How to change a user’s role?
  2. How to allow editor to edit privacy page / settings only?
  3. Reset default roles and capabilities
  4. What do unfiltered_html and unfiltered_upload actually filter?
  5. Temporary capability for current_user_can()
  6. Is it possible to add new user Roles?
  7. Temporarily give ‘manage_options’ capability
  8. Hide specific admin users’ posts
  9. Code needed to only show users own posts in a multi-user account
  10. Restrict Author to pick from media library, but not upload media
  11. How to allow registered users to change their user role through frontend?
  12. Remove Ability for Administrators to Delete Administrators
  13. Order users by custom user meta
  14. how to change user roles for users who doesn’t have any. (about 8000 users)
  15. List total number of users that are authors
  16. Shold I manually add ‘cap’ to admin role ?
  17. Getting a user role from the user login name
  18. Auto Delete Users (auto_delete_users)
  19. New Roles and Capabilities in WordPress
  20. Why is wp-login redirecting to the home page when I use this function?
  21. Allow contributor to view own scheduled post
  22. Editor and contributor roles not correct after adding function
  23. WordPress Super Admin
  24. How are roles stored in the database?
  25. How to delete user roles?
  26. How to ‘unpublish’ or ‘hide’ posts when user role changes?
  27. Can’t manage to make translate_user_role() work
  28. I am adding a new class to my body tag if the logged in user is subscriber, need help
  29. How to Orderby User Role?
  30. Prevent custom user role to add new pages
  31. Hide Specific User Page
  32. The delete_posts capability?
  33. Capabilites not working [closed]
  34. get approved users only ( ultimate member plugin )
  35. Create Super Admin that cant be deleted
  36. Customizer – Allow user editor to change website title and tagline
  37. Customized role that allows users to “Submit for Review” instead of “Publish”
  38. Query users which have same dynamically generated roles as the current user
  39. change role of wordpress users when they edit profile
  40. Assign second role to user
  41. Adding Capabilities to a WordPress User Account
  42. Change post status based on user role
  43. Display User Role Next To Comment
  44. Allow an editor to change the author
  45. Parent User and Child User – relate users
  46. New user is assigned 2 roles: customer and superadmin
  47. bbPress plugin moderator roles
  48. how to set any post creation for pending status and let the admin approve it first?
  49. How to give remove role editing permission from user
  50. Allowing user to edit posts based on the post status
  51. How to have kind of a technical writer role in wp website
  52. Assigning certain authors to specific editors
  53. How to make the Newsletter plugin visible to users with author privileges?
  54. WP welcome email depending on user role
  55. Allow user role “salesman” to view only “client” role users
  56. Purpose of Adding Capability to Role But Not Grant?
  57. bbPress: How to set conditional for specific user -or- user role, to be displayed in user profile
  58. Menu page with list of users
  59. How to check user role?
  60. Get and display a user’s profile info?
  61. How to get a users list by who created them?
  62. Paypal API and WordPress
  63. Updater user with multiple roles
  64. Custom user types getting html sanitized in posts
  65. Is there a Capability that checks as true for non-logged in users?
  66. Hiding custom theme functionality using capabilities
  67. Use PHP code to create custom user roles. Call it once?
  68. custom plugin not visible to some user roles
  69. How to write conditions based on user capabilities not on user role?
  70. What Capability is required to let a role RUN code in Edit Theme?
  71. remove_cap nothing changes
  72. get_post_meta with related user
  73. How to change a user’s role depending on date registered?
  74. Need to block user role from accessing bbPress all together
  75. Show special backend content for certain roles
  76. Retrieve user roles but exclude default roles
  77. Why can my subscribers create new posts for review?
  78. Custom Role read_private_posts Not Working
  79. Disabled delete_others_posts if post is from admin
  80. logout users with specific role after close browser tab
  81. How to hide Add new Term area for taxonomy terms for specific role (Client)
  82. Saving user meta “member_id” based on user role
  83. Change logo url based on WP user role
  84. show the author’s role along with the name in the single.php
  85. Display specific post categories to specific user roles
  86. Role and Capabilities: How do I allow user role to access theme options without enabling ‘manage_options’?
  87. How to Enable registration email for a custom user role?
  88. Restrict custom fields based on user roles
  89. How can I add the ability for a user to add/edit administrators?
  90. Allow signed in users (subscribers) to see their drafts
  91. How to sync user database with “user role editor” plugin enabled
  92. Need to create admin user without capability to create user
  93. Give editor ability to edit custom settings without access to Main Settings
  94. How to assign role to a custom registration form?
  95. How to add user roles? [closed]
  96. Check if specific role exists
  97. Get users by rôle in a list
  98. WordPress show content if current user get spesific role and spesific meta value
  99. WordPress users roles wp-admin
  100. User roles empty