First time here? Check out the FAQ!
0

Can I delete users from the mysql auth_user table with no bad side effects?

We have had a rash of spam postings and I looked into the database to see if I could find information about the users.

Can I delete all the undesired users or is there a way to do this with some mysql command/script? Are there related tables I need to update as well?

tim's avatar
51
tim
asked 2014-12-13 19:23:09 -0600, updated 2014-12-13 19:23:36 -0600
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

Instead of doing it from mysql I did it from the django admin page:

YourSiteUrl/admin

and

.../admin/auth/user/

however, I don't believe this is recommended by the implementors of the software - it is recommended to block them, however this is a tedious task if there are more than a few (and when the spammers sign up it usually means trouble...)

tim's avatar
51
tim
answered 2014-12-14 22:25:45 -0600, updated 2014-12-14 22:26:55 -0600
edit flag offensive 0 remove flag delete link

Comments

This is ok, but the side effect will be a deletion of all user's content. Better might be changing status of the user account to blocked or merging it to some other account by the command `merge_users`.

Evgeny's avatar Evgeny (2014-12-19 02:57:37 -0600) edit

thanks. we actually want to delete all the users content in these instances - these were spam accounts.

tim's avatar tim (2014-12-21 13:04:53 -0600) edit
add a comment see more comments