Delete inactive and never-logged-in Drupal users
- Posted by Ron Williams on January 14th, 2010
![drupal.org[1].png](http://hardwarehacks.com/files/imagecache/post_size/drupal.org%5B1%5D.png "Drupal Logo")
If you're interested in quickly deleting old and never used Drupal user accounts through mysql whether via ssh, phpMyAdmin, or other web interface use the following:
DELETE FROM users WHERE access < [unix date of oldest login to be kept]
DELETE FROM users WHERE access < 0
This should quickly delete the user accounts. I've used this in Drupal 4.7, 5, and 6.
- Posted by Ron Williams on January 14th, 2010
![drupal.org[1].png](http://hardwarehacks.com/files/drupal.org[1].png "Drupal Logo")
If you're interested in quickly deleting old and never used Drupal user accounts through mysql whether via ssh, phpMyAdmin, or other web interface use the following:
DELETE FROM users WHERE access < [unix date of oldest login to be kept]
DELETE FROM users WHERE access < 0
This should quickly delete the user accounts. I've used this in Drupal 4.7, 5, and 6.
