{"id":240,"date":"2010-09-16T11:57:35","date_gmt":"2010-09-16T11:57:35","guid":{"rendered":"http:\/\/www.knowledgement.ie\/?p=240"},"modified":"2010-09-16T11:57:35","modified_gmt":"2010-09-16T11:57:35","slug":"reset-a-forgotten-oscommerce-admin-password","status":"publish","type":"post","link":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/","title":{"rendered":"Reset a Forgotten osCommerce Admin Password"},"content":{"rendered":"

Last week while working on an osCommerce <\/a>project for a customer, I forgot to note down the admin password for the administrator end. Administrator interface provides access to manage your ecommerce website built on osCommerce platform. But in this case there was no way that I could remember the password for the store and hence the only option was to reset it from the database. So here are the steps that you may use to reset the admin password of your oscommerce webshop:<\/p>\n

Using phpMyAdmin<\/h2>\n
    \n
  1. Use phpMyAdmin or similar utility and login to your database<\/li>\n
  2. Go to the table administrators<\/li>\n
  3. Edit the row with admin in the field “user_name<\/strong>“<\/li>\n
  4. Enter\u00a037408dac283835de2d133073408b4609:23 in the password field and save<\/li>\n<\/ol>\n

    Using Command Line<\/h2>\n
      \n
    1. Login to MySQL through command line
      \n{code type=codetype}mysql -u root -p{\/code}<\/li>\n
    2. Change the database to your oscommerce database in our case it is called osc so
      \n{code type=codetype}USE DATABASE osc;{\/code}<\/li>\n
    3. Run the following query
      \n{code type=codetype}UPDATE \u00a0`osc`.`administrators` SET \u00a0`user_password` = \u00a0‘37408dac283835de2d133073408b4609:23’ WHERE \u00a0`administrators`.`id` =1 LIMIT 1;{\/code}<\/li>\n<\/ol>\n

      Once you have completed the steps above, stuff the row your password has now been reset to “admin” so login with username admin and password admin and Happy Selling!!!<\/p>\n

      Target Integration is expert in providing ecommerce platforms based on oscommerce, Virtuemart and Magento. Contact us to discuss your specific needs.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Last week while working on an osCommerce project for a customer, I forgot to note down the admin password for…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[40,53,54],"class_list":["post-240","post","type-post","status-publish","hentry","category-article","tag-finance","tag-market","tag-themeforest"],"acf":[],"yoast_head":"\nReset a Forgotten osCommerce Admin Password -<\/title>\n<meta name=\"description\" content=\"Last week while working on an osCommerce project for a customer, I forgot to note down the admin password for the administrator end.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reset a Forgotten osCommerce Admin Password -\" \/>\n<meta property=\"og:description\" content=\"Last week while working on an osCommerce project for a customer, I forgot to note down the admin password for the administrator end.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/\" \/>\n<meta property=\"og:site_name\" content=\"Target Integration\" \/>\n<meta property=\"article:published_time\" content=\"2010-09-16T11:57:35+00:00\" \/>\n<meta name=\"author\" content=\"Aman Thakral\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aman Thakral\" \/>\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:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/\"},\"author\":{\"name\":\"Aman Thakral\",\"@id\":\"https:\/\/targetintegration.com\/#\/schema\/person\/9956d46591619b474ed534d4bae9a37d\"},\"headline\":\"Reset a Forgotten osCommerce Admin Password\",\"datePublished\":\"2010-09-16T11:57:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/\"},\"wordCount\":240,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/targetintegration.com\/#organization\"},\"keywords\":[\"finance\",\"market\",\"themeforest\"],\"articleSection\":[\"Article\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/\",\"url\":\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/\",\"name\":\"Reset a Forgotten osCommerce Admin Password -\",\"isPartOf\":{\"@id\":\"https:\/\/targetintegration.com\/#website\"},\"datePublished\":\"2010-09-16T11:57:35+00:00\",\"description\":\"Last week while working on an osCommerce project for a customer, I forgot to note down the admin password for the administrator end.\",\"breadcrumb\":{\"@id\":\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/targetintegration.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Reset a Forgotten osCommerce Admin Password\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/targetintegration.com\/#website\",\"url\":\"https:\/\/targetintegration.com\/\",\"name\":\"Target Integration\",\"description\":\"Empowering You!\",\"publisher\":{\"@id\":\"https:\/\/targetintegration.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/targetintegration.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/targetintegration.com\/#organization\",\"name\":\"Target Integration\",\"url\":\"https:\/\/targetintegration.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/targetintegration.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/targetintegration.com\/wp-content\/uploads\/\/2021\/05\/ti-logo2-2.svg\",\"contentUrl\":\"https:\/\/targetintegration.com\/wp-content\/uploads\/\/2021\/05\/ti-logo2-2.svg\",\"width\":172,\"height\":65,\"caption\":\"Target Integration\"},\"image\":{\"@id\":\"https:\/\/targetintegration.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/targetintegration.com\/#\/schema\/person\/9956d46591619b474ed534d4bae9a37d\",\"name\":\"Aman Thakral\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/targetintegration.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5d3832136f194dc02b46be42471b0a19833e6a89e0c27d4f36549afb93d2a431?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5d3832136f194dc02b46be42471b0a19833e6a89e0c27d4f36549afb93d2a431?s=96&d=mm&r=g\",\"caption\":\"Aman Thakral\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Reset a Forgotten osCommerce Admin Password -","description":"Last week while working on an osCommerce project for a customer, I forgot to note down the admin password for the administrator end.","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:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/","og_locale":"en_US","og_type":"article","og_title":"Reset a Forgotten osCommerce Admin Password -","og_description":"Last week while working on an osCommerce project for a customer, I forgot to note down the admin password for the administrator end.","og_url":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/","og_site_name":"Target Integration","article_published_time":"2010-09-16T11:57:35+00:00","author":"Aman Thakral","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Aman Thakral","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/#article","isPartOf":{"@id":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/"},"author":{"name":"Aman Thakral","@id":"https:\/\/targetintegration.com\/#\/schema\/person\/9956d46591619b474ed534d4bae9a37d"},"headline":"Reset a Forgotten osCommerce Admin Password","datePublished":"2010-09-16T11:57:35+00:00","mainEntityOfPage":{"@id":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/"},"wordCount":240,"commentCount":0,"publisher":{"@id":"https:\/\/targetintegration.com\/#organization"},"keywords":["finance","market","themeforest"],"articleSection":["Article"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/","url":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/","name":"Reset a Forgotten osCommerce Admin Password -","isPartOf":{"@id":"https:\/\/targetintegration.com\/#website"},"datePublished":"2010-09-16T11:57:35+00:00","description":"Last week while working on an osCommerce project for a customer, I forgot to note down the admin password for the administrator end.","breadcrumb":{"@id":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/targetintegration.com\/en_us\/reset-a-forgotten-oscommerce-admin-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/targetintegration.com\/"},{"@type":"ListItem","position":2,"name":"Reset a Forgotten osCommerce Admin Password"}]},{"@type":"WebSite","@id":"https:\/\/targetintegration.com\/#website","url":"https:\/\/targetintegration.com\/","name":"Target Integration","description":"Empowering You!","publisher":{"@id":"https:\/\/targetintegration.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/targetintegration.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/targetintegration.com\/#organization","name":"Target Integration","url":"https:\/\/targetintegration.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/targetintegration.com\/#\/schema\/logo\/image\/","url":"https:\/\/targetintegration.com\/wp-content\/uploads\/\/2021\/05\/ti-logo2-2.svg","contentUrl":"https:\/\/targetintegration.com\/wp-content\/uploads\/\/2021\/05\/ti-logo2-2.svg","width":172,"height":65,"caption":"Target Integration"},"image":{"@id":"https:\/\/targetintegration.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/targetintegration.com\/#\/schema\/person\/9956d46591619b474ed534d4bae9a37d","name":"Aman Thakral","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/targetintegration.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5d3832136f194dc02b46be42471b0a19833e6a89e0c27d4f36549afb93d2a431?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5d3832136f194dc02b46be42471b0a19833e6a89e0c27d4f36549afb93d2a431?s=96&d=mm&r=g","caption":"Aman Thakral"}}]}},"_links":{"self":[{"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/posts\/240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/comments?post=240"}],"version-history":[{"count":0,"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/posts\/240\/revisions"}],"wp:attachment":[{"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/media?parent=240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/categories?post=240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/targetintegration.com\/en_us\/wp-json\/wp\/v2\/tags?post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}