By haisam on

I just deleted user 1 by mistake. How do I fix this problem? I do have access to the DB.

⋅ Categories: Drupal 5.x

Comments

haisam’s picture

haisam commented

I solved it this way:

INSERT INTO `users` VALUES (1,'admin','MYENCRYPTEDPASSWD','MYEMAILADDRESS',0,0,0,'','',1142527238,1170204672,1170203335,1,'0','','','MYEMAILADDRESS','a:0:{}');

ragavendra_bn’s picture

ragavendra_bn commented

THanks for the solution haisam. It worked for me on 6.x

sushilmasti’s picture

sushilmasti commented

This is what worked for me in 6.13 - thanks for making it so easy....

INSERT INTO `users` (`uid`, `name`, `pass`, `mail`, `mode`, `sort`, `threshold`, `theme`, `signature`, `created`, `access`, `login`, `status`, `timezone`, `language`, `picture`, `init`, `data`, `timezone_name`, `signature_format`) VALUES
(1, 'NAME', 'ENCRYPTED-PASSWORD', EMAIL-ADDRESS', 0, 0, 0, '', '', 1233105816, 1249610800, 1249111744, 1, '', '', '', 'EMAIL-ADDRESS', 'a:0:{}', '', 3);