{"id":980,"date":"2022-03-14T17:54:20","date_gmt":"2022-03-14T16:54:20","guid":{"rendered":"https:\/\/farofaro.com\/comment-changer-le-mot-de-passe-dun-utilisateur-wordpress-via-la-base-de-donnee\/"},"modified":"2022-03-17T17:01:48","modified_gmt":"2022-03-17T16:01:48","slug":"how-to-change-the-password-of-a-wordpress-user-via-the-database","status":"publish","type":"post","link":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/","title":{"rendered":"How to change the password of a WordPress user via the database?"},"content":{"rendered":"

We present you with a handy tutorial on how to create a new password when the Forgotten Password function of WordPress does not work (HS mail server for example) or within the framework of a hacking which would have limited the access of a user account.<\/p>\n

Localisation of “wp_user” table in PhpMyAdmin<\/h2>\n

User passwords are stored in the MYSQL database of your WordPress site. Let’s where to find them and how to change them.<\/p>\n

For this we will have to edit the database. The easiest way is to use PhpMyAdmin. It is generally the tool provided by your host. If this is the first time you connect to it, your host will be able to guide you towards its access.<\/p>\n

For your information, if you can’t find the access to the database (name, password…), they can be found in the “wp-config.php” file located at the root of your WordPress site.<\/p>\n

\n
\"\"<\/figure>\n<\/div>\n

Once connected to PhpMyadmin, you will find your database in the left column, if it is not already selected, click on it. You should see the list of tables.<\/p>\n

By default, Worpress uses the prefix “wp_” to name the beginning of each table. If this prefix has not been modified, you should find the list of users in the “wp_users” table. If the prefix has been modified then the structure will be “prefixname_users”.<\/p>\n

\n
\"\"<\/figure>\n<\/div>\n

Click on this table to display its contents. It displays all the users of your site.<\/p>\n

Creating a new password<\/h2>\n

In the “user_login” column, you will find the names of the users. In the column “user_pass”, you find the password assigned to the user. It is of course encrypted for security reasons.<\/p>\n

To change the password, click on “Edit”.
\nLocate the “user_pass” line on the text field to its right and add your new password.<\/p>\n

We must also encrypt it. In the “Function” drop-down list, select “MD5”, then click “Execute” to save.<\/p>\n

\"\"<\/figure>\n

Your new password is now saved and encrypted! You can go to the WordPress login page to access your site’s administration again.<\/p>\n","protected":false},"excerpt":{"rendered":"We present you with a handy tutorial on how to create a new password when the Forgotten Password function of WordPress does not work (HS mail server for example) or within the framework of a hacking which would have limited the access of a user account. Localisation of “wp_user” table in PhpMyAdmin User passwords are… View Article<\/a>","protected":false},"author":1,"featured_media":433,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[26,28],"tags":[],"class_list":["post-980","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriel-en","category-wordpress-en"],"acf":[],"yoast_head":"\nHow to change the password of a WordPress user via the database? - Faro<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to change the password of a WordPress user via the database? - Faro\" \/>\n<meta property=\"og:description\" content=\"We present you with a handy tutorial on how to create a new password when the Forgotten Password function of WordPress does not work (HS mail server for example) or within the framework of a hacking which would have limited the access of a user account. Localisation of “wp_user” table in PhpMyAdmin User passwords are... View Article\" \/>\n<meta property=\"og:url\" content=\"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Faro\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/farodigitalstudio\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-14T16:54:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-17T16:01:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/farofaro.com\/wp-content\/uploads\/2022\/02\/mot-de-passe.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1482\" \/>\n\t<meta property=\"og:image:height\" content=\"635\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Charles\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Charles\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/\"},\"author\":{\"name\":\"Charles\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/#\\\/schema\\\/person\\\/e670a724b4e139b031acd19a1cab3e37\"},\"headline\":\"How to change the password of a WordPress user via the database?\",\"datePublished\":\"2022-03-14T16:54:20+00:00\",\"dateModified\":\"2022-03-17T16:01:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/\"},\"wordCount\":359,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/farofaro.com\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/mot-de-passe.png\",\"articleSection\":[\"Tutoriel\",\"Wordpress\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/\",\"url\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/\",\"name\":\"How to change the password of a WordPress user via the database? - Faro\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/farofaro.com\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/mot-de-passe.png\",\"datePublished\":\"2022-03-14T16:54:20+00:00\",\"dateModified\":\"2022-03-17T16:01:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/farofaro.com\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/mot-de-passe.png\",\"contentUrl\":\"https:\\\/\\\/farofaro.com\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/mot-de-passe.png\",\"width\":1482,\"height\":635},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/en\\\/how-to-change-the-password-of-a-wordpress-user-via-the-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/farofaro.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to change the password of a WordPress user via the database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/#website\",\"url\":\"https:\\\/\\\/farofaro.com\\\/\",\"name\":\"Site du studio Faro\",\"description\":\"Studio de cr\u00e9ation digitale\",\"publisher\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/farofaro.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/#organization\",\"name\":\"Site du studio Faro\",\"url\":\"https:\\\/\\\/farofaro.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/farofaro.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/faro-logo-01-450x142px.png\",\"contentUrl\":\"https:\\\/\\\/farofaro.com\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/faro-logo-01-450x142px.png\",\"width\":450,\"height\":142,\"caption\":\"Site du studio Faro\"},\"image\":{\"@id\":\"https:\\\/\\\/farofaro.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/farodigitalstudio\",\"https:\\\/\\\/www.instagram.com\\\/faro_digital_studio\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/farofaro\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/farofaro.com\\\/#\\\/schema\\\/person\\\/e670a724b4e139b031acd19a1cab3e37\",\"name\":\"Charles\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b1fadefe6cde07bfa03d8d072ac6eeba232ab6d48f10c93fef569e4e2a015ef1?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b1fadefe6cde07bfa03d8d072ac6eeba232ab6d48f10c93fef569e4e2a015ef1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b1fadefe6cde07bfa03d8d072ac6eeba232ab6d48f10c93fef569e4e2a015ef1?s=96&d=mm&r=g\",\"caption\":\"Charles\"},\"sameAs\":[\"https:\\\/\\\/farofaro.com\"],\"url\":\"https:\\\/\\\/farofaro.com\\\/en\\\/author\\\/adminwp\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to change the password of a WordPress user via the database? - Faro","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:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/","og_locale":"en_US","og_type":"article","og_title":"How to change the password of a WordPress user via the database? - Faro","og_description":"We present you with a handy tutorial on how to create a new password when the Forgotten Password function of WordPress does not work (HS mail server for example) or within the framework of a hacking which would have limited the access of a user account. Localisation of “wp_user” table in PhpMyAdmin User passwords are... View Article","og_url":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/","og_site_name":"Faro","article_publisher":"https:\/\/www.facebook.com\/farodigitalstudio","article_published_time":"2022-03-14T16:54:20+00:00","article_modified_time":"2022-03-17T16:01:48+00:00","og_image":[{"width":1482,"height":635,"url":"https:\/\/farofaro.com\/wp-content\/uploads\/2022\/02\/mot-de-passe.png","type":"image\/png"}],"author":"Charles","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Charles","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/#article","isPartOf":{"@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/"},"author":{"name":"Charles","@id":"https:\/\/farofaro.com\/#\/schema\/person\/e670a724b4e139b031acd19a1cab3e37"},"headline":"How to change the password of a WordPress user via the database?","datePublished":"2022-03-14T16:54:20+00:00","dateModified":"2022-03-17T16:01:48+00:00","mainEntityOfPage":{"@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/"},"wordCount":359,"commentCount":0,"publisher":{"@id":"https:\/\/farofaro.com\/#organization"},"image":{"@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/#primaryimage"},"thumbnailUrl":"https:\/\/farofaro.com\/wp-content\/uploads\/2022\/02\/mot-de-passe.png","articleSection":["Tutoriel","Wordpress"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/","url":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/","name":"How to change the password of a WordPress user via the database? - Faro","isPartOf":{"@id":"https:\/\/farofaro.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/#primaryimage"},"image":{"@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/#primaryimage"},"thumbnailUrl":"https:\/\/farofaro.com\/wp-content\/uploads\/2022\/02\/mot-de-passe.png","datePublished":"2022-03-14T16:54:20+00:00","dateModified":"2022-03-17T16:01:48+00:00","breadcrumb":{"@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/#primaryimage","url":"https:\/\/farofaro.com\/wp-content\/uploads\/2022\/02\/mot-de-passe.png","contentUrl":"https:\/\/farofaro.com\/wp-content\/uploads\/2022\/02\/mot-de-passe.png","width":1482,"height":635},{"@type":"BreadcrumbList","@id":"https:\/\/farofaro.com\/en\/how-to-change-the-password-of-a-wordpress-user-via-the-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/farofaro.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to change the password of a WordPress user via the database?"}]},{"@type":"WebSite","@id":"https:\/\/farofaro.com\/#website","url":"https:\/\/farofaro.com\/","name":"Site du studio Faro","description":"Studio de cr\u00e9ation digitale","publisher":{"@id":"https:\/\/farofaro.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/farofaro.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/farofaro.com\/#organization","name":"Site du studio Faro","url":"https:\/\/farofaro.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/farofaro.com\/#\/schema\/logo\/image\/","url":"https:\/\/farofaro.com\/wp-content\/uploads\/2023\/03\/faro-logo-01-450x142px.png","contentUrl":"https:\/\/farofaro.com\/wp-content\/uploads\/2023\/03\/faro-logo-01-450x142px.png","width":450,"height":142,"caption":"Site du studio Faro"},"image":{"@id":"https:\/\/farofaro.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/farodigitalstudio","https:\/\/www.instagram.com\/faro_digital_studio\/","https:\/\/www.linkedin.com\/company\/farofaro\/"]},{"@type":"Person","@id":"https:\/\/farofaro.com\/#\/schema\/person\/e670a724b4e139b031acd19a1cab3e37","name":"Charles","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/b1fadefe6cde07bfa03d8d072ac6eeba232ab6d48f10c93fef569e4e2a015ef1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b1fadefe6cde07bfa03d8d072ac6eeba232ab6d48f10c93fef569e4e2a015ef1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b1fadefe6cde07bfa03d8d072ac6eeba232ab6d48f10c93fef569e4e2a015ef1?s=96&d=mm&r=g","caption":"Charles"},"sameAs":["https:\/\/farofaro.com"],"url":"https:\/\/farofaro.com\/en\/author\/adminwp\/"}]}},"jetpack_featured_media_url":"https:\/\/farofaro.com\/wp-content\/uploads\/2022\/02\/mot-de-passe.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/posts\/980","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/comments?post=980"}],"version-history":[{"count":2,"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/posts\/980\/revisions"}],"predecessor-version":[{"id":1053,"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/posts\/980\/revisions\/1053"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/media\/433"}],"wp:attachment":[{"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/media?parent=980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/categories?post=980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/farofaro.com\/en\/wp-json\/wp\/v2\/tags?post=980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}