Ask Your Question
0

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

asked 2014-12-13 19:23:09 -0600

tim gravatar image

updated 2014-12-13 19:23:36 -0600

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?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2014-12-14 22:25:45 -0600

tim gravatar image

updated 2014-12-14 22:26:55 -0600

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...)

edit flag offensive delete link more

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 gravatar imageEvgeny ( 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 gravatar imagetim ( 2014-12-21 13:04:53 -0600 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2014-12-13 19:23:09 -0600

Seen: 260 times

Last updated: Dec 14 '14