Magento Forum

   
errased admin username and password in mysql help! 
 
michinashop
Jr. Member
 
Total Posts:  7
Joined:  2008-10-14
 

I tried to delete the australiapost module and since i cannot enter to my store.
i tried with send password to email but it comes “wrong email or email was not found”
I think the last chance i have is to change it from the mysql, or?

how should i do it?

Thank you in advance

 
Magento Community Magento Community
Magento Community
Magento Community
 
Discovery
Enthusiast
 
Total Posts:  767
Joined:  2007-12-29
 

http://www.magentocommerce.com/wiki/groups/227/how_to_reset_your_password

 
Magento Community Magento Community
Magento Community
Magento Community
 
michinashop
Jr. Member
 
Total Posts:  7
Joined:  2008-10-14
 

it doesnt work…
MySQL lieferte ein leeres Resultat zurück (d. h. null Zeilen). (die Abfrage dauerte 0.0004 sek.)
SQL-Befehl:
SELECT *
FROM `admin_user`
LIMIT 0 , 30

I tried the same but i think i deleted the admin user cause it happen nothing…
hier my mysql code:

--
-- Tabellenstruktur für Tabelle `admin_user`
--

CREATE TABLE IF NOT EXISTS `admin_user` (
`user_id` mediumint(9) unsigned NOT NULL auto_increment,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`username` varchar(40) NOT NULL,
`password` varchar(40) NOT NULL,
`created` datetime NOT NULL default ‘0000-00-00 00:00:00’,
`modified` datetime default NULL,
`logdate` datetime default NULL,
`lognum` smallint(5) unsigned NOT NULL default ‘0’,
`reload_acl_flag` tinyint(1) NOT NULL default ‘0’,
`is_active` tinyint(1) NOT NULL default ‘1’,
`extra` text,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Users’ AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `admin_user`
--

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top