{"id":2406,"date":"2012-10-24T16:54:50","date_gmt":"2012-10-24T16:54:50","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/10\/24\/308-password-change-via-database\/"},"modified":"2021-03-22T18:25:23","modified_gmt":"2021-03-22T22:25:23","slug":"prestashop-admin-password-database","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/","title":{"rendered":"How to Change Your PrestaShop Admin Password by Database"},"content":{"rendered":"

There are times when you may forget your password. In these instances, you can have the PrestaShop admin password<\/strong> changed via email. If, for some reason, you do not receive the email for the new password, you will not be able to log into the admin area with it. <\/p>\n\n\n\n

There is a fix, however. <\/p>\n\n\n\n

You will need to change your password by modifying the database directly. This can be a bit awkward and intimidating, however following the steps below should allow you to change your PrestaShop admin password in your database<\/strong> without any trouble. Click here for more information on PrestaShop Hosting<\/a>.<\/p>\n\n\n\n

This article assumes you are using a hosting account that uses cPanel software for managing your hosting account.<\/p>\n\n\n\n

Modifying your admin password via database in PrestaShop 1.5<\/h2>\n\n\n\n
  1. First you will need to log into the cpanel<\/a> for your hosting account.<\/li>
  2. \"file-manager\"<\/a>\n
    \u00a0<\/div>\n

    Once logged in, you will need to locate the File Manager<\/strong>, found in the Files<\/em> category, and click on the icon.<\/p>\n

    \u00a0<\/div>\n<\/li>
  3. \"select-config-folder\"<\/a>\n
    \u00a0<\/div>\n

    Once in the File Manager<\/em>, find and double click on the config<\/strong> folder. This will take you to a list of all files within that folder.<\/p>\n

    \u00a0<\/div>\n<\/li>
  4. \n

    Look for the settings.inc.php file<\/strong>. Highlight it by clicking on it once. Then, using the icons across the top, find and click on the Code Edit<\/strong> feature. Click Edit<\/strong> from the pop up that will appear to continue.<\/p>\n

    <<\/p>\n<\/li>

  5. \"select-cookie-key\"<\/a>\n
    \u00a0<\/div>\n

    Once inside the settings.inc.php<\/strong> file, locate the setting named _COOKIE_KEY<\/strong> and copy the string. You can see the area below that we highlighted. You may want to save it temporarily to a word processing document such as notepad, Notepad++, MS Word, etc. Close the file once you have the key.<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/div>\n<\/li>
  6. \"select-phpmyadmin\"<\/a>\n
    \u00a0<\/div>\n

    Go back to your cPanel and find the Databases<\/em> category. From there, click on the PhPMyAdmin<\/strong> tool.<\/p>\n

    \u00a0<\/div>\n<\/li>
  7. Once inside, select (click on) the correct database for your PrestaShop 1.5 application from the list of databases on the left hand sidebar.<\/li><\/ol>\n\n\n\n

    <\/a><\/p>\n\n\n\n

    1. \"select-phpmyadmin\"<\/a>\n
      \u00a0<\/div>\n

      You will then see a list of the database tables in the left sidebar. Scroll down and select the one named ps_employee<\/strong>.<\/p>\n

      Note that your PrestaShop database prefix might not begin with ps_<\/strong><\/p>\n

      \u00a0<\/div>\n<\/li>
    2. \"select-admin-data-row\"<\/a>\n
      \u00a0<\/div>\n

      This opens the table data information. Find your admin user from the list of data rows and click on the Edit<\/strong> link on the right side of that particular row.<\/p>\n

      \u00a0<\/p>\n

      \u00a0<\/div>\n<\/li>
    3. \"Select<\/a>\n
      \u00a0<\/div>\n

      Find the password row, it is named passwd.<\/em> There are two columns you will need to edit. The first is the Function<\/strong> column.<\/p>\n

      \u00a0<\/div>\n
      \"Select<\/a><\/figure>

      <\/p>\n

      \u00a0<\/div>\n

      Use the dropdown and select the MD5<\/strong> option.<\/p>\n

      \u00a0<\/div>\n<\/li>
    4. \"Fill<\/a>\n
      \u00a0<\/div>\n

      The second column is the Value<\/strong> column. For this column, paste the _COOKIE_KEY<\/strong> value you saved earlier and attach your new password directly to the end of the key with no spaces. Be sure to use a real password and not anything easy like NEWPASS1234<\/em> that we used in the example.<\/p>\n

      \u00a0<\/div>\n<\/li>
    5. After you have entered the new password, scroll down to the bottom of the page and click the GO<\/strong> button to save the new information.\n

      \u00a0<\/p>\n<\/li><\/ol>\n\n\n\n

      You should now be able to log into your admin area<\/a> with your new password.<\/p>\n","protected":false},"excerpt":{"rendered":"

      There are times when you may forget your password. In these instances, you can have the PrestaShop admin password changed via email. If, for some reason, you do not receive the email for the new password, you will not be able to log into the admin area with it. There is a fix, however. You Read More ><\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[92,4299,4288,4305],"tags":[],"class_list":["post-2406","post","type-post","status-publish","format-standard","hentry","category-prestashop","category-security","category-website","category-databases"],"acf":[],"yoast_head":"\nChange PrestaShop Admin Password by Database<\/title>\n<meta name=\"description\" content=\"Need to change your admin password through the database? Learn how in this guide.\" \/>\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.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change PrestaShop Admin Password by Database\" \/>\n<meta property=\"og:description\" content=\"Need to change your admin password through the database? Learn how in this guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2012-10-24T16:54:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-22T22:25:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\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:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to Change Your PrestaShop Admin Password by Database\",\"datePublished\":\"2012-10-24T16:54:50+00:00\",\"dateModified\":\"2021-03-22T22:25:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/\"},\"wordCount\":538,\"commentCount\":30,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png\",\"articleSection\":[\"Prestashop\",\"Security\",\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/\",\"name\":\"Change PrestaShop Admin Password by Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png\",\"datePublished\":\"2012-10-24T16:54:50+00:00\",\"dateModified\":\"2021-03-22T22:25:23+00:00\",\"description\":\"Need to change your admin password through the database? Learn how in this guide.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png\",\"width\":988,\"height\":543,\"caption\":\"file-manager\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Change Your PrestaShop Admin Password by Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Change PrestaShop Admin Password by Database","description":"Need to change your admin password through the database? Learn how in this guide.","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.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/","og_locale":"en_US","og_type":"article","og_title":"Change PrestaShop Admin Password by Database","og_description":"Need to change your admin password through the database? Learn how in this guide.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-10-24T16:54:50+00:00","article_modified_time":"2021-03-22T22:25:23+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png","type":"","width":"","height":""}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to Change Your PrestaShop Admin Password by Database","datePublished":"2012-10-24T16:54:50+00:00","dateModified":"2021-03-22T22:25:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/"},"wordCount":538,"commentCount":30,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png","articleSection":["Prestashop","Security","Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/","name":"Change PrestaShop Admin Password by Database","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png","datePublished":"2012-10-24T16:54:50+00:00","dateModified":"2021-03-22T22:25:23+00:00","description":"Need to change your admin password through the database? Learn how in this guide.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Password_Change-Password-Via-Database_file-manager-pl.png","width":988,"height":543,"caption":"file-manager"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/prestashop-admin-password-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Change Your PrestaShop Admin Password by Database"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2406","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2406"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2406\/revisions"}],"predecessor-version":[{"id":70384,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2406\/revisions\/70384"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}