I have a large website where users will be able to store data. When a new user signs up they are given a password and I use sessions to maintain their login status.
Each user has 6 tables but they are all in the same database. For now, i'm using the same login for each person - since their information is verified against the DB, I didn't know if I should rework the layout to split up the tables into different databases depending on username or if 1 database was OK. Is it also OK to have the one login for everyone to use for the database connection? Or should I change that?
