Greenhorn query: Logins

[aubdearns]

Is creating a table with user names and passwords the same thing as creating multiple users of your database and granting them permissions and so forth?

That is, I of course have a root password for my database. I put the following at the top of each page that needs to access the database:

$dbconnect = mysql_connect("localhost", "root", "password");

So even if someone is "logging in" and I query the user table to see if what they input matches their username and password and show them results accordingly, I am still connecting to my database with the root password, above.

In sum, I am confused about the difference between connecting to the db as the main root user vs the hundreds of users who need logins and passwords to "sign in"

Thank you!

Audrey 😕

[nnichols]

The people "signing in" against details contained in your sites database are "signing in" to your site not your database server.

[aubdearns]

Thank you for your prompt reply. So I take it it is neither advisible nor necessary to create users at the database level for all users.

[nnichols]

You definitely want to avoid creating a db user for every site user

[aubdearns]

thanks for clearing that up. over and out.