{"id":1402,"date":"2021-07-26T06:46:15","date_gmt":"2021-07-26T11:46:15","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=1402"},"modified":"2021-11-16T06:31:43","modified_gmt":"2021-11-16T12:31:43","slug":"how-to-manage-wordpress-users","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/","title":{"rendered":"How to Manage WordPress Users"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #212121;color:#212121\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #212121;color:#212121\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/#how_to_reset_a_wordpress_users_password_using_sql\" >How to Reset a WordPress Users Password using SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/#how_to_get_a_list_of_subscribers\" >How to Get a List of Subscribers?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<h3 class=\"wp-block-heading\" id=\"how_to_reset_a_wordpress_user_password_using_sql\"><span class=\"ez-toc-section\" id=\"how_to_reset_a_wordpress_users_password_using_sql\"><\/span>How to Reset a WordPress Users Password using SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can quickly set a WordPress users password to the new \u2018somenewpassword\u2019 text as seen below, assuming that the user login is \u2018theirusername\u2019. Change the username and password to whatever you\u2019d like and <a href=\"https:\/\/wordpress.org\/support\/article\/resetting-your-password\/#through-mysql-command-line\">execute the query<\/a>.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_users \n  SET user_pass = MD5( 'somenewpassword' ) \n    WHERE user_login = \u2018theirusername\u2019;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_get_a_list_of_subscribers\"><span class=\"ez-toc-section\" id=\"how_to_get_a_list_of_subscribers\"><\/span>How to Get a List of Subscribers?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The below example will get a list of registered users who are assigned the role of subscriber:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT wp_users.ID, wp_users.user_nicename, wp_users.user_email\n  FROM wp_users \n  JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id \n    WHERE wp_usermeta.meta_key = 'wp_capabilities'\n      AND wp_usermeta.meta_value like '%subscriber%'\n  ORDER BY wp_users.user_nicename;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that we\u2019ve gone over how to manage WordPress Users by using SQL, check out some of our other <a href=\"https:\/\/www.knownhost.com\/kb\/\">knowledge base<\/a> articles.<\/p>\n\n\n\n<p><meta http-equiv=\"content-type\" content=\"text\/html; charset=utf-8\"><a href=\"https:\/\/www.knownhost.com\/\">KnownHost<\/a>\u00a0offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team is ready to help you with requests should you need our assistance. You\u2019re not using KnownHost for the best web hosting experience? Well, why not? Check with\u00a0our Sales team\u00a0to see what can KnownHost do for you in improving your web hosting experience<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Reset a WordPress Users Password using SQL? You can quickly set a WordPress users password to the new \u2018somenewpassword\u2019 text as seen below, assuming that the user login is \u2018theirusername\u2019. Change the username and password to whatever you\u2019d like and execute the query. How to Get a List of Subscribers? The below example [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146],"tags":[251,252,186,255,106],"class_list":["post-1402","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-blogs","tag-cms","tag-mysql","tag-sql","tag-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Manage WordPress Users - KnownHost<\/title>\n<meta name=\"description\" content=\"In this guide, we will teach you how to manage WordPress users as an admin on your KnownHost website. Contact support if you need more help.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Manage WordPress Users - KnownHost\" \/>\n<meta property=\"og:description\" content=\"In this guide, we will teach you how to manage WordPress users as an admin on your KnownHost website. Contact support if you need more help.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-26T11:46:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-16T12:31:43+00:00\" \/>\n<meta name=\"author\" content=\"Jonathan K. W.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan K. W.\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-manage-wordpress-users\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-manage-wordpress-users\\\/\"},\"author\":{\"name\":\"Jonathan K. W.\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"headline\":\"How to Manage WordPress Users\",\"datePublished\":\"2021-07-26T11:46:15+00:00\",\"dateModified\":\"2021-11-16T12:31:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-manage-wordpress-users\\\/\"},\"wordCount\":165,\"keywords\":[\"blogs\",\"cms\",\"mysql\",\"SQL\",\"wordpress\"],\"articleSection\":[\"WordPress\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-manage-wordpress-users\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-manage-wordpress-users\\\/\",\"name\":\"How to Manage WordPress Users - KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"datePublished\":\"2021-07-26T11:46:15+00:00\",\"dateModified\":\"2021-11-16T12:31:43+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"description\":\"In this guide, we will teach you how to manage WordPress users as an admin on your KnownHost website. Contact support if you need more help.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-manage-wordpress-users\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-manage-wordpress-users\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-manage-wordpress-users\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Manage WordPress Users\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\",\"name\":\"KnownHost\",\"description\":\"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\",\"name\":\"Jonathan K. W.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"caption\":\"Jonathan K. W.\"},\"sameAs\":[\"https:\\\/\\\/www.knownhost.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Manage WordPress Users - KnownHost","description":"In this guide, we will teach you how to manage WordPress users as an admin on your KnownHost website. Contact support if you need more help.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/","og_locale":"en_US","og_type":"article","og_title":"How to Manage WordPress Users - KnownHost","og_description":"In this guide, we will teach you how to manage WordPress users as an admin on your KnownHost website. Contact support if you need more help.","og_url":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/","og_site_name":"KnownHost","article_published_time":"2021-07-26T11:46:15+00:00","article_modified_time":"2021-11-16T12:31:43+00:00","author":"Jonathan K. W.","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathan K. W.","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/"},"author":{"name":"Jonathan K. W.","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"headline":"How to Manage WordPress Users","datePublished":"2021-07-26T11:46:15+00:00","dateModified":"2021-11-16T12:31:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/"},"wordCount":165,"keywords":["blogs","cms","mysql","SQL","wordpress"],"articleSection":["WordPress"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/","url":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/","name":"How to Manage WordPress Users - KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"datePublished":"2021-07-26T11:46:15+00:00","dateModified":"2021-11-16T12:31:43+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"description":"In this guide, we will teach you how to manage WordPress users as an admin on your KnownHost website. Contact support if you need more help.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/how-to-manage-wordpress-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to Manage WordPress Users"}]},{"@type":"WebSite","@id":"https:\/\/www.knownhost.com\/kb\/#website","url":"https:\/\/www.knownhost.com\/kb\/","name":"KnownHost","description":"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knownhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b","name":"Jonathan K. W.","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","caption":"Jonathan K. W."},"sameAs":["https:\/\/www.knownhost.com"]}]}},"_links":{"self":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/1402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/comments?post=1402"}],"version-history":[{"count":0,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/1402\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=1402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=1402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=1402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}