In Q2A you can go to the user page (e.g. example.com/user/username), click "Edit user" and select the user type.
If you need to do it via the database for some reason, you need to find the user in the qa_users table, and edit the "level" column back to 0.