Would you use one or two tables for username and password?
database-design, mysql, security, sql
Solution
No I would just do this:
id, username, password.
Where id is just autoincrement, username is a varchar of 20 (or so, depending on your needs) and password is an MD5 or SHA1 hashed password with a salt.
Using two tables for this just doesn't make sense. Then you need to work with joins to get the data. And that's just an unnecessary burden.
Problem
Is it any safer to create a table holding user information and another one for their passwords than using the same table for everything?