We Talk Coding

How many MYSQL databases r needed to create a sign up page on your website?

how many MYSQL databases? is it one for every user or what?

Public Comments

1. 1 database usually
2. You can have one table of users on one database. There you'll have to store user's name, password (in a form of SHA1 so not to show password on hacker's attack) and e-mail where you'll send registration info and restore password (because database does not know it). By the way, all these things are done by CMS like Joomla, Drupal, I personally use e107 though it is not so quickly developing, but is stable.
3. simple auth. web site, one data table with in a/one database will be done. users(user_id, user_pass, create_date...) or two data tables, users (user_id, user_pass, create_data, user_role, ...) roles (role_id ...)