Set all accounts to be blocked / banned

[Yoh Asakura]

Hi,

I know there`s a way to let all the accounts blocked (state = 5 on table login). State = 0 means that the account is ok to login, state = 5 means blocked permanently. How can I set all the accounts to state = 5?

Could anyone do a sript sql so I can load on my database? or a npc would be fine also.

I believe it`s more using doing it on SSH...I have MySQL version 5.6.

Regards。

Solved by @@Dastgir

 UPDATE `login` SET `state` =5 WHERE account_id>1;