Magento - Reset the admin password

Hi, if u getting trouble in login from admin side because of password then no worry u can reset it simply.

SELECT * FROM admin_user;

above query should retrieve the admin user data. here find the user name name to which u want to reset password. and apply following query


UPDATE admin_user SET password=CONCAT(MD5('admin123')) WHERE username='admin';

u can also do this in mysql query browser

Comments

Post a Comment

Popular posts from this blog

Magento Navigation menu of CMS pages

Image
Hi Buddy's, yeah, navigation menu of CMS pages.. As we aware Magento can provide us options to  make the CMS pages,.also we can display it on front end. . but things is those who are non IT people want to do such task then?? I have solution for it.. with Navigation menu of CMS pages.. Main point is, you don’t need of any developer / programmer this functionality, and you can manage it by your own.  By just single time installation or on one click. Backend configuration: Go on Menu: CMS >> Pages Add new CMS page over there, In general tab there is options to select the status of “Show in Horizontal Menu”. If you “enabled” it then it would be show on frontend, at anytime you can make it “enabled” or “disabled” as per your need. Here there is options to display on menu or not.. Frontend view. Currently, I enabled the “about us” and “customer service”, so it display here. However here I display in Horizontal, of course it p...
Read more

Magento Admin login problem

I had a new installation of magento. But I was unable to login as an administrator. I went to the admin login page, entered correct username and password but was redirected to the same login page. Error message is displayed when I enter wrong username or password. But nothing is displayed and I am redirected to the same login page when I insert correct username and password. luckily i found solutions: The solution is to modify the core Magento code. Open app/code/core/Mage/Core/Model/Session/Abstract/Varien.php . Comment out the lines 80 to 83. The line number may vary according to the Magento version. But these lines are present somewhere near line 80. You have to comment the comma (,) in line: $this->getCookie()->getPath()//, // set session cookie params session_set_cookie_params( $this->getCookie()->getLifetime(), $this->getCookie()->getPath()//, //$this->getCookie()->getDomain(), //$this->getCookie()->isSecure(), ...
Read more

Magento Reindexing problem - take too long time

There are problem in reindexing in magento many times due to number of factors: The number of products The number of store views The apache/lighttpd timeout setting The php.ini maximum execution time & script input time The lock file is still place from the previous time can preventing it running again one more thing VPS or dedicated server is must have for Magento. here i paste the trick/tips for the same. First of all increase your execution time value from the .htaccess # php_value memory_limit 64M php_value memory_limit 128M php_value max_execution_time 18000 Now open your shell/terminal: go on upto "public_html/app/shell" use "ls -l" command, to list out the files. there is one indexer.php file in the list. Commads: php indexer.php --info (Will shows list of allowed indexers) php indexer.php --reindex all (Reindex data by all indexers) If you wish to reindex one by one then use following commands: php in...
Read more