Here’s the two tables & data needed as an sql query, copy the code below.
Use phpMyAdmin and go to the SQL tab, paste the sql and hit Go.
If all goes well head for the MODx Manager login page.
The Manager login is admin & temp123, change once you’ve logged in successfully.
-- --------------------------------------------------------
--
-- Table structure for table `modx_manager_users`
--
DROP TABLE IF EXISTS `modx_manager_users`;
CREATE TABLE IF NOT EXISTS `modx_manager_users` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Contains login information for backend users.' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `modx_manager_users`
--
INSERT INTO `modx_manager_users` (`id`, `username`, `password`) VALUES
(1, 'admin', 'cca8dd8babd4c9996c8dfee788a49d18');
-- --------------------------------------------------------
--
-- Table structure for table `modx_user_attributes`
--
DROP TABLE IF EXISTS `modx_user_attributes`;
CREATE TABLE IF NOT EXISTS `modx_user_attributes` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`internalKey` int(10) NOT NULL DEFAULT '0',
`fullname` varchar(100) NOT NULL DEFAULT '',
`role` int(10) NOT NULL DEFAULT '0',
`email` varchar(100) NOT NULL DEFAULT '',
`phone` varchar(100) NOT NULL DEFAULT '',
`mobilephone` varchar(100) NOT NULL DEFAULT '',
`blocked` int(1) NOT NULL DEFAULT '0',
`blockeduntil` int(11) NOT NULL DEFAULT '0',
`blockedafter` int(11) NOT NULL DEFAULT '0',
`logincount` int(11) NOT NULL DEFAULT '0',
`lastlogin` int(11) NOT NULL DEFAULT '0',
`thislogin` int(11) NOT NULL DEFAULT '0',
`failedlogincount` int(10) NOT NULL DEFAULT '0',
`sessionid` varchar(100) NOT NULL DEFAULT '',
`dob` int(10) NOT NULL DEFAULT '0',
`gender` int(1) NOT NULL DEFAULT '0' COMMENT '0 - unknown, 1 - Male 2 - female',
`country` varchar(5) NOT NULL DEFAULT '',
`state` varchar(25) NOT NULL DEFAULT '',
`zip` varchar(25) NOT NULL DEFAULT '',
`fax` varchar(100) NOT NULL DEFAULT '',
`photo` varchar(255) NOT NULL DEFAULT '' COMMENT 'link to photo',
`comment` text,
PRIMARY KEY (`id`),
KEY `userid` (`internalKey`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Contains information about the backend users.' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `modx_user_attributes`
--
INSERT INTO `modx_user_attributes` (`id`, `internalKey`, `fullname`, `role`, `email`, `phone`, `mobilephone`, `blocked`, `blockeduntil`, `blockedafter`, `logincount`, `lastlogin`, `thislogin`, `failedlogincount`, `sessionid`, `dob`, `gender`, `country`, `state`, `zip`, `fax`, `photo`, `comment`) VALUES
(1, 1, 'Default admin account', 1, '[email protected]', '', '', 0, 0, 0, 29, 1313436669, 1313436758, 0, 'stts8rj53lof5dnodot3gjqbf5', 0, 0, '', '', '', '', '', '');
