Lost admin password

[wylie1]

I hope somebody out there can help me.

I have lost my admin password.

Was looking through all the forum answers to try and reset it but I have failed.

I am willing to pay somebody a small fee if they can fix it before I get my laptop and throw it out the window

[Guest]

George,

 

Log into your hosting account provider and use myphpadmin to delete the current password from the administrators table. Then log back into the admin area, it will tell you there is NO current password and ask you to create a new one.

 

Then, write it down in a safe place :thumbsup:

 

 

 

Chris

[wylie1]

George,

 

Log into your hosting account provider and use myphpadmin to delete the current password from the administrators table. Then log back into the admin area, it will tell you there is NO current password and ask you to create a new one.

 

Then, write it down in a safe place :thumbsup:

 

 

 

Chris

 

Thanks for the reply

I am logged into myphpadmin

 

I have the following tabs

Database sql status variables carsets engines proceses export import

 

Where do I go from here??

[chadcloman]

Here's an add-on that resets it for you: http://addons.oscommerce.com/info/5857

[wylie1]

Tried that on already.

It did not work

 

Thanks Anyway

 

Here's an add-on that resets it for you: http://addons.oscommerce.com/info/5857

[Guest]

Login to PHPMyAdmin and run the following SQL:

 

--
-- Table structure for table `administrators`
--

DROP TABLE IF EXISTS `administrators`;
CREATE TABLE IF NOT EXISTS `administrators` (
 `id` int(11) NOT NULL auto_increment,
 `user_name` varchar(32) character set latin1 collate latin1_bin NOT NULL default '',
 `user_password` varchar(40) NOT NULL default '',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `administrators`
--

INSERT INTO `administrators` (`id`, `user_name`, `user_password`) VALUES
(1, 'admin', 'a2bf8f4df75dbb4a237e6cf28a19e3e2:5b');

 

This will reset the admin to username is admin and password is password

[wylie1]

I get the following error

 

Error

SQL query:

 

--

-- Table structure for table `administrators`

--

DROP TABLE IF EXISTS `administrators` ;

 

 

MySQL said:

 

#1046 - No database selected

 

 

 

Login to PHPMyAdmin and run the following SQL:

 

--
-- Table structure for table `administrators`
--

DROP TABLE IF EXISTS `administrators`;
CREATE TABLE IF NOT EXISTS `administrators` (
 `id` int(11) NOT NULL auto_increment,
 `user_name` varchar(32) character set latin1 collate latin1_bin NOT NULL default '',
 `user_password` varchar(40) NOT NULL default '',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `administrators`
--

INSERT INTO `administrators` (`id`, `user_name`, `user_password`) VALUES
(1, 'admin', 'a2bf8f4df75dbb4a237e6cf28a19e3e2:5b');

 

This will reset the admin to username is admin and password is password

[Guest]

When you are in PHPMyAdmin you need to select your database, probably on the left handside and then click on SQL at the top.

[wylie1]

OK done that ,Now I get the following ( it still does not work

--

-- Table structure for table `administrators`

--

 

DROP TABLE IF EXISTS `administrators`;

CREATE TABLE IF NOT EXISTS `administrators` (

`id` int(11) NOT NULL auto_increment,

`user_name` varchar(32) character set latin1 collate latin1_bin NOT NULL default '',

`user_password` varchar(40) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

--

-- Dumping data for table `administrators`

--

 

INSERT INTO `administrators` (`id`, `user_name`, `user_password`) VALUES

(1, 'admin', 'a2bf8f4df75dbb4a237e6cf28a19e3e2:5b');

 

When you are in PHPMyAdmin you need to select your database, probably on the left handside and then click on SQL at the top.

[artful]

OK done that ,Now I get the following ( it still does not work

--

-- Table structure for table `administrators`

--

 

DROP TABLE IF EXISTS `administrators`;

CREATE TABLE IF NOT EXISTS `administrators` (

`id` int(11) NOT NULL auto_increment,

`user_name` varchar(32) character set latin1 collate latin1_bin NOT NULL default '',

`user_password` varchar(40) NOT NULL default '',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

 

--

-- Dumping data for table `administrators`

--

 

INSERT INTO `administrators` (`id`, `user_name`, `user_password`) VALUES

(1, 'admin', 'a2bf8f4df75dbb4a237e6cf28a19e3e2:5b');

 

 

Use this:

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)

);

[wylie1]

How I get this error

 

Error

SQL query:

 

USE this : DROP TABLE IF EXISTS administrators;

 

 

MySQL said:

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':

DROP TABLE IF EXISTS administrators' at line 1

 

 

 

 

Use this:

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)

);