7

Someone did a mistake while creating his account and i want to delete the account from database so he can create a new account with the same username

top 4 comments
sorted by: hot top controversial new old
[-] computerboss@sh.itjust.works 2 points 1 year ago

Try it and tell us what happens!

/s

Honestly in my experience messing with databases in production is not a good idea. I recommend making a test instance to see what happens. The alternative is to backup the database and try it. My guess is that it will work, and there shouldn't be a huge problem from it, but there might be some strange problems that pop up from it.

[-] soeren@iusearchlinux.fyi 3 points 1 year ago

Good idea i always test in production :) yeah i will have to figure it out myself or the user just takes a different name.

[-] ptz@dubvee.org 2 points 1 year ago

I had to do that earlier, and haven't had any issues. Just make sure you remove them from both person and local_user tables. They're linked on person.id = local_user.person_id.

I exported the user's row data from both tables before deleting them just to be cautious.

[-] soeren@iusearchlinux.fyi 1 points 1 year ago

thanks for the info

this post was submitted on 10 Jun 2023
7 points (100.0% liked)

Lemmy Support

4645 readers
27 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS