Set all accounts to be blocked / banned

[Yoh Asakura 9]

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; 

Edited July 5, 2015 by Yoh Asakura