How can I reset all of user's points?

Question

I wanna change all points as 0. How can I reset all of user's points?

Comments

You'll have to remove all content that generates points (e.g. upvotes, downvotes, selected answers, answers, questions, etc). Why would you do that?

Answer 1

log in to your phpMyAdmin or mysql and run the following command#

UPDATE qa_userpoints SET points = "0";

Comments

That's not how points work in Q2A. That's just a denormalized value to allow for quick access. A point change would reset the update