admin password

[ecuaje]

Hello, my website oscommerce admin is www.miuclothing.com/admin I forgot the password, the user name is good.

how can i reset it or change the password, i am the administrator,owner, please help..

 

reply or comment please.. my email is. ecuaje@yahoo.com

thanks

[Jack_mcs]

Run the following via phpmyadmin, or your preferred method. It changes the login to admin, admin. You can then login and reset it to what you want.

DROP TABLE IF EXISTS administrators;
CREATE TABLE administrators (
 id int NOT NULL auto_increment,
 user_name varchar(32) binary NOT NULL,
 user_password varchar(40) NOT NULL,
 PRIMARY KEY (id)
);

INSERT INTO `administrators` (`id`, `user_name`, `user_password`) VALUES (1,'admin','39a89a28169b53c7e58438558adc5e37:7b');