Cannot Log Backend of Joomla Help - Joomla! Forum - community, help and support

hi,

i have huge problem. think have somehow accidentally deleted admin , password, cannot log backend of joomla website make changes. same error message username or password don't match or don't have account.

i have tried playing around phpmyadmin had no luck.

how go on creating new admin user , password. have tried manual sql code of adding new user:

insert `jos31_users`
(`name`, `username`, `password`, `params`)
values ('administrator2', 'admin2',
'd2064d358136996bd22421584a7cb33e:trd7tvkhx6dmeommbvxymg0vuxea4199', '');
insert `jos31_user_usergroup_map` (`user_id`,`group_id`)
values (last_insert_id(),'8');

the problem don't have "jos tables", doesnt work me.

can 1 please me this.

thanks

when you're logged phpmyadmin , looking inside joomla database, should able see table prefix data. "something_" in front of each of listed tables.

you're joomla database table prefix data listed within "global configuration" configuration.php file follows:

public $dbprefix = "something_"

naturally, "something_" whatever specific joomla database prefix is.

once know table prefix particular joomla database using... take manual sql code adding new user referenced in original post , edit instances of "jos31_xxxx" in code database table prefix instead.

jim