delete all users from the users table

  • Resolved Bloke

    (@bloke)


    12 years, 1 month ago

    I need a SQL script I can run in phpMyAdmin to delete all users from the users table and also all meta tables from wp_usermeta with capabilities of wpsc_anonymous. The issue with Wp-ecommerce causing many wpsc_anonymous users is too much. Link I know they are working on it and sometimes the cron runs and clears most of them. I have to delete each user and then go and delete each one from wp_usermeta table.

Viewing 1 replies (of 1 total)
  • Thread Starter Bloke

    (@bloke)

    12 years, 1 month ago

    I found this solution. I ran this in phpMyAdmin

    DELETE FROM wp_users WHERE ID > [number after last real user]

    Then run this:

    DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users)

Viewing 1 replies (of 1 total)

The topic ‘delete all users from the users table’ is closed to new replies.