Reseting password for administrator for oscommerce

The misplace of the passwords is always a problem, especially if it is something important. And there is nothing more important when you have an online store and you can not log in to the backend to administrate your products.

There are several ways to reset your password:

If you have access to the database (using phpmyadmin, for example) you must go to the administrators table (it's easy to find, it has the same name), there you will see the users list and hashed passwords. Export the table on your hard disk (just to be safe, even you are the only administrator) and empty it (the sql for that is 'truncate table administrators'). The next time you access your admin log in (http://www.youronlinestor.com/admin/) you will be asked to input your name and your password to create a new administrator. If there are more than one admins (others than you) go to the exported file and copy the queries to insert them back into the table. They look like this:

INSERT INTO `administrators` (`id`, `user_name`, `user_password`) VALUES (1, 'admin', 'e5ae9781b99ddefda2be67727dd5cc96:b3');

Another method you can try is to edit your login.php file and insert a tep_db_query() call at the beginning of it in order to update your admin password to whatever you want to reset it to. Make sure you use tep_encrypt_password() to wrap around that text.

The line will look like this:

tep_db_query("update administrators set admin_password = '" . tep_encrypt_password('theNewPassword') . "' where user_name = 'admin'");

After saving the file and uploading it to the server just go to the login page of the admin console, it will automatically update that password for you, then you can strip that line of code (leave it as it was before the modification) and login like normal.

Related Articles

seo search engine optimisation The search engine optimisation part is very important for websites - they have to match certain criteria in order to appear as often as possible in the search results on Google and Bing. SEO (search engine optimization) starts from site / online store / platform development because it involves a specific structure of the pages, it involves an ease to browse for the visitors (for your clients) and it involves quicky loading when accessed. Our sites are delived already optimized, but if you have already a solution developed by someone else we analize your website and we offer consultancy - we'll tell you about the options you have about to boost its visibility and organic traffic.

realizăm site-uriWe develop websites to present your activity to the world and applications for internet that help you organize your activity as eficient as possible and without loses (in money, time and energy) wherever you are. Do you need an online store or a tool available for you anytime? We can develop that as long you reserve a domain name and some hosting space, the app is our job.

As an extension to your site or web app we can provide an app for your smartpone / table to keep you always informed about what's happening with the product already developed.

developing appsWe develop web applications and mobile apps (Android) for various companies and organisations according to their specifications and requirements. The apps are being used by employees and partners to work more efficient and with less costs for the company: the web applications can be accessed through the browsers installed on smartphones and tablets but the usage of a complementary mobile app can make efficiency to go up (it can increase the communication between people or it can show things not so important on PC).

We offer support for the applications used now and we develop them further using modern technologies.

Consulting bussiness online / itWe offer consultancy about the informatic system you have installed and we offer sollutions to make the more efficient, to improve and develop them further, we analize the activities inside your company and / organisation and we offer sollutions for the projects you want to develop.

If you don't have a website, an online store, a web application or a mobile app (Android) but you want to develop one for yourself or your company we offer the initial consultancy, the one that's necessary before starting anything about such project.

Share this URL on social social

"Cu capãtul arcurilor, trecînd,
rãzboinicii
mîngîie roua..."

Yosa Buson (1715-1783)

facebook sharing button
twitter sharing button
messenger sharing button
reddit sharing button
wordpress sharing button
whatsapp sharing button
tumblr sharing button
pinterest sharing button
blogger sharing button