{"id":334,"date":"2012-01-17T16:25:31","date_gmt":"2012-01-17T21:25:31","guid":{"rendered":"http:\/\/www.ryanbelanger.com\/?p=334"},"modified":"2012-01-17T16:25:31","modified_gmt":"2012-01-17T21:25:31","slug":"plesk-users-passwords","status":"publish","type":"post","link":"https:\/\/ryanbelanger.com\/?p=334","title":{"rendered":"Plesk users passwords"},"content":{"rendered":"<p>If you need to get your Plesk users&#8217;s password, the information is stored in a database named <strong>psa<\/strong> and in a table named <strong>accounts. \u00a0<\/strong>The passwords are not hashed, they are only stored as BLOBs in Plesk 10 or later (previous versions were clear text) so a simple CONVERT can list them.<\/p>\n<p>Start mysql and prompt for password. \u00a0Then select database to use.<\/p>\n<pre>mysql -p\nmysql&gt; use psa<\/pre>\n<p>Run the query\u00a0(Plesk 10)<\/p>\n<pre>SELECT\na.id,\nCONCAT(m.mail_name,\"@\", d.name) AS email_address,\nCONVERT(a.password USING utf8) AS password\nFROM mail m\nLEFT OUTER JOIN domains d on d.id=m.dom_id\nLEFT OUTER JOIN accounts a ON a.id=m.account_id<\/pre>\n<p>Optionally, you can add the following search criteria<\/p>\n<pre>WHERE d.name IN ('domain1.com','domain2.com')<\/pre>\n<p>References:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.linuxweblog.com\/blogs\/sandip\/20100609\/plesk-email-users-and-passwords\">http:\/\/www.linuxweblog.com\/blogs\/sandip\/20100609\/plesk-email-users-and-passwords<\/a><\/li>\n<li><a href=\"http:\/\/www.search-this.com\/2007\/02\/07\/view-all-email-account-passwords-in-plesk\/\">http:\/\/www.search-this.com\/2007\/02\/07\/view-all-email-account-passwords-in-plesk\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>If you need to get your Plesk users&#8217;s password, the information is stored in a database named psa and in a table named accounts. \u00a0The passwords are not hashed, they are only stored as BLOBs in Plesk 10 or later (previous versions were clear text) so a simple CONVERT can list them. Start mysql and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-334","post","type-post","status-publish","format-standard","hentry","category-tips"],"_links":{"self":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts\/334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=334"}],"version-history":[{"count":0,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=\/wp\/v2\/posts\/334\/revisions"}],"wp:attachment":[{"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ryanbelanger.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}