You would've had to have set up MySQL when you set up your server. This includes the MySQL Query Browser.
Open the MySQL Query Browser and log in.
Looking through the list in the right pane, go to the "accounts" table. Clicking the little arrow to the left of it will expand it so that you can see all the columns it contains. Double click on:
Then click "Execute" at the top right.
This will now show you all the details you need in the main frame. Scroll down, inspecting the status of each account. Any that you find that aren't 0s, look at the account name and character name to decide whether you want that to stay, or if it needs to be changed.
If it needs to be changed, click the edit button at the bottom. Click the field you want to change to highlight it. Hit enter, type a 0, then hit enter again. Once you've changed any number of them, hit the "Apply Changes" button at the bottom.
That any help to you?
(This fix is for if you're using Windows. If you're using Linux, I'm gonna be no help to you at all

)