WARNING the following recommendation will nuke/delete/kill all existing users on a Joomla site - only use it if thats what you want to doYou can run the following SQL in phpMyAdmin, this will nuke ALL USERS and will create a single super admin called "admin" with a password of "admin" - after running this you should change that password.
By removing all existing users you can be sure that the hackers changes are removed.
If this is the true nature of your login problems then the following will fix this.
Code:
-- phpMyAdmin SQL Dump
-- version 2.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 05, 2008 at 09:44 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3-1ubuntu6.2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `FRESH`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_aro`
--
DROP TABLE IF EXISTS `jos_core_acl_aro`;
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro` (
`aro_id` int(11) NOT NULL auto_increment,
`section_value` varchar(240) NOT NULL default '0',
`value` varchar(240) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`aro_id`),
UNIQUE KEY `jos_gacl_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `jos_core_acl_aro`
--
INSERT INTO `jos_core_acl_aro` VALUES(10, 'users', '62', 0, 'Administrator', 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_aro_groups`
--
DROP TABLE IF EXISTS `jos_core_acl_aro_groups`;
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_groups` (
`group_id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`lft` int(11) NOT NULL default '0',
`rgt` int(11) NOT NULL default '0',
PRIMARY KEY (`group_id`),
KEY `parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `jos_core_acl_aro_groups`
--
INSERT INTO `jos_core_acl_aro_groups` VALUES(17, 0, 'ROOT', 1, 22);
INSERT INTO `jos_core_acl_aro_groups` VALUES(28, 17, 'USERS', 2, 21);
INSERT INTO `jos_core_acl_aro_groups` VALUES(29, 28, 'Public Frontend', 3, 12);
INSERT INTO `jos_core_acl_aro_groups` VALUES(18, 29, 'Registered', 4, 11);
INSERT INTO `jos_core_acl_aro_groups` VALUES(19, 18, 'Author', 5, 10);
INSERT INTO `jos_core_acl_aro_groups` VALUES(20, 19, 'Editor', 6, 9);
INSERT INTO `jos_core_acl_aro_groups` VALUES(21, 20, 'Publisher', 7, 8);
INSERT INTO `jos_core_acl_aro_groups` VALUES(30, 28, 'Public Backend', 13, 20);
INSERT INTO `jos_core_acl_aro_groups` VALUES(23, 30, 'Manager', 14, 19);
INSERT INTO `jos_core_acl_aro_groups` VALUES(24, 23, 'Administrator', 15, 18);
INSERT INTO `jos_core_acl_aro_groups` VALUES(25, 24, 'Super Administrator', 16, 17);
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_aro_sections`
--
DROP TABLE IF EXISTS `jos_core_acl_aro_sections`;
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_sections` (
`section_id` int(11) NOT NULL auto_increment,
`value` varchar(230) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`section_id`),
UNIQUE KEY `value_aro_sections` (`value`),
UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
KEY `hidden_aro_sections` (`hidden`),
KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `jos_core_acl_aro_sections`
--
INSERT INTO `jos_core_acl_aro_sections` VALUES(10, 'users', 1, 'Users', 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_core_acl_groups_aro_map`
--
DROP TABLE IF EXISTS `jos_core_acl_groups_aro_map`;
CREATE TABLE IF NOT EXISTS `jos_core_acl_groups_aro_map` (
`group_id` int(11) NOT NULL default '0',
`section_value` varchar(240) NOT NULL default '',
`aro_id` int(11) NOT NULL default '0',
UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_core_acl_groups_aro_map`
--
INSERT INTO `jos_core_acl_groups_aro_map` VALUES(25, '', 10);
-- --------------------------------------------------------
--
-- Table structure for table `jos_users`
--
DROP TABLE IF EXISTS `jos_users`;
CREATE TABLE IF NOT EXISTS `jos_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '0',
`gid` tinyint(3) unsigned NOT NULL default '1',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;
--
-- Dumping data for table `jos_users`
--
INSERT INTO `jos_users` VALUES(62, 'Administrator', 'admin', 'admin@127.0.0.1', '1b6c9ca60503cf3e784fb05611320fc8:NEQuJ5psDbwIXt2Q', 'Super Administrator', 0, 1, 25, '2007-11-09 23:41:17', '0000-00-00 00:00:00', '', 'expired=\nexpired_time=');
