NPDS : Gestion de contenu et de communauté
Content & Community Management System (CCMS) robuste, sécurisé, complet, performant, parlant vraiment français, libre (Open-Source) et gratuit.
45 visiteur(s) et 0 membre(s) en ligne.
Autres infos
Activité du Site
Pages vues depuis 25/05/2001 : 108 405 148
- Nb. de membres 8 693
- Nb. d'articles 1 695
- Nb. de forums 26
- Nb. de sujets 8
- Nb. de critiques 92
Index du forum »» English and others languages Support »» Root password reset
Nouveau sujet
Root password reset#11818Répondre
3Contributeur(s)
3 Modérateur(s)
Anonyme
After trying to drop, and remake, the authors table I'm still not able to change the root password and login.
(Yes, I forgot it...) :paf
I've tried the example, NULL, and others but nothing I set it to works. I even installed phpmyadmin just in case the format was different.
How do I get back in as root/admin on my site?
Regards,
Seeker
(Yes, I forgot it...) :paf
I've tried the example, NULL, and others but nothing I set it to works. I even installed phpmyadmin just in case the format was different.
How do I get back in as root/admin on my site?
Regards,
Seeker
axel
Try in PhpMyAdmin / SQL /Excute :
DROP TABLE authors;
CREATE TABLE authors (
aid varchar(30) NOT NULL default '',
name varchar(50) default NULL,
url varchar(60) default NULL,
email varchar(60) default NULL,
pwd varchar(40) default NULL,
counter int(11) NOT NULL default '0',
radminarticle tinyint(2) NOT NULL default '0',
radmintopic tinyint(2) NOT NULL default '0',
radminleft tinyint(2) NOT NULL default '0',
radminright tinyint(2) NOT NULL default '0',
radminuser tinyint(2) NOT NULL default '0',
radminmain tinyint(2) NOT NULL default '0',
radminsurvey tinyint(2) NOT NULL default '0',
radminsection tinyint(2) NOT NULL default '0',
radminlink tinyint(2) NOT NULL default '0',
radminephem tinyint(2) NOT NULL default '0',
radminfilem tinyint(2) NOT NULL default '0',
radminhead tinyint(2) NOT NULL default '0',
radminfaq tinyint(2) NOT NULL default '0',
radmindownload tinyint(2) NOT NULL default '0',
radminforum tinyint(2) NOT NULL default '0',
radminreviews tinyint(2) NOT NULL default '0',
radminsdv tinyint(2) NOT NULL default '0',
radminlnl tinyint(2) NOT NULL default '0',
radminsuper tinyint(2) NOT NULL default '1',
PRIMARY KEY (aid)
) TYPE=MyISAM;
#
# Contenu de la table `authors`
#
INSERT INTO authors VALUES ('Root', 'Root', '', '', 'd.8V.L9nSMMvE', 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
This will restore the default root, login : Root & password : Password
Be careful, this will delete all root you have created since you started your website
[and Xcuse for bad english :-) )
DROP TABLE authors;
CREATE TABLE authors (
aid varchar(30) NOT NULL default '',
name varchar(50) default NULL,
url varchar(60) default NULL,
email varchar(60) default NULL,
pwd varchar(40) default NULL,
counter int(11) NOT NULL default '0',
radminarticle tinyint(2) NOT NULL default '0',
radmintopic tinyint(2) NOT NULL default '0',
radminleft tinyint(2) NOT NULL default '0',
radminright tinyint(2) NOT NULL default '0',
radminuser tinyint(2) NOT NULL default '0',
radminmain tinyint(2) NOT NULL default '0',
radminsurvey tinyint(2) NOT NULL default '0',
radminsection tinyint(2) NOT NULL default '0',
radminlink tinyint(2) NOT NULL default '0',
radminephem tinyint(2) NOT NULL default '0',
radminfilem tinyint(2) NOT NULL default '0',
radminhead tinyint(2) NOT NULL default '0',
radminfaq tinyint(2) NOT NULL default '0',
radmindownload tinyint(2) NOT NULL default '0',
radminforum tinyint(2) NOT NULL default '0',
radminreviews tinyint(2) NOT NULL default '0',
radminsdv tinyint(2) NOT NULL default '0',
radminlnl tinyint(2) NOT NULL default '0',
radminsuper tinyint(2) NOT NULL default '1',
PRIMARY KEY (aid)
) TYPE=MyISAM;
#
# Contenu de la table `authors`
#
INSERT INTO authors VALUES ('Root', 'Root', '', '', 'd.8V.L9nSMMvE', 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
This will restore the default root, login : Root & password : Password
Be careful, this will delete all root you have created since you started your website
[and Xcuse for bad english :-) )
Anonyme
I just came back to note that the instructions I got didn't have the "Password" listed. I guessed at "password" but I used "p" and not "P". Everything is fine in the world again thank you!
Seeker
Seeker