If you accidentally remove the 0 user (UID = 0) in DRUPAL 6

By donmc, 1 February, 2015

Will typically give you and error message like this:

Could not login with user ID #0. This is typically caused by importing a MySQL database dump from a faulty tool [error] which re-numbered the anonymous user ID in the users table. See http://drupal.org/node/1029506 for help recovering from this situation.


SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
INSERT INTO `users` (`uid`, `name`, `pass`, `mail`, `mode`, `sort`, `threshold`, `theme`, `signature`, `created`, `access`, `login`, `status`, `timezone`, `language`, `picture`, `init`, `data`) 
VALUES ('0', '', '', '', 0, 0, 0, '', '', 0, 0, 0, 0, NULL, '', '', '', NULL);