Anyone help plz: database problem

amplec

New Member
Messages
9
Reaction score
0
Points
0
I have an admin panel of my site. But i have forgotten the admin panels password, that is why i'm being unable to access my admin panel. Can i recover or reset or create password by editing databases in phpmyadmin?


It's the starting of my sql database:

PHP:
-- phpMyAdmin SQL Dump
-- version 2.11.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Server version: 5.0.45
-- PHP Version: 5.2.5
--
--

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `d`
--

-- --------------------------------------------------------

--
-- Table structure for table `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
  `aId` int(11) NOT NULL auto_increment,
  `aUsername` varchar(255) NOT NULL,
  `aPassword` varchar(255) NOT NULL,
  `aPermissions` text NOT NULL,
  PRIMARY KEY  (`aId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`aId`, `aUsername`, `aPassword`, `aPermissions`) VALUES
(1, 'admin', 'f8c5a65f897fda65e5379b351f9f13e1b552781a', 'ALL');

-- --------------------------------------------------------
 
Last edited:

misson

Community Paragon
Community Support
Messages
2,572
Reaction score
72
Points
48
If you know what hash algorithm was used, you can set the password using an UPDATE statement:

Code:
UPDATE admins SET aPassword='...' WHERE aId=1

Code:
INSERT INTO `admins` (`aId`, `aUsername`, `aPassword`, `aPermissions`) VALUES
(1, 'admin', '******', 'ALL');

Never post sensitive information, even if it's hashed. Fortunately, you're going to change your password, so it doesn't matter in this case.
 

xgreenberetx

New Member
Messages
57
Reaction score
1
Points
0
If all else fails just use phpmyadmin and select the table with the admin name and password, and click the pencil icon to edit, then change the password. Then you can always do a password change to re encrypt it.
 
Top