use one account/password for all. Otherwise, when you write your PHP/ASP
script, you'd have to have an mysql database open for each guest. MySQL
should be able to handle the number of guests that you indicate.
For each guest, store their username in the database and a MD5 hash of their
password. DON"T store the password. For instance, you might use:
$hash = MD5($username.$password);
$query = INSERT INTO mytable (username,password)
VALUES($username,$hash)";
rick
-----Original Message-----
From: Darren Smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 5:12 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] newbie - correct use of Grant in mysql
Hello
I know this is off topic but I have tried at the mysql newsgroup/mailing
list but the just ignored me and you all seem like such nice people :)
I am setting up a kind of PHP guestbook that will allow the user to log in
and update their details.
Should I create a new user using grant for ever (unique) person in the
guestbook so that way they only have the rights to alter certain specified
fields of their own data or do I create one user for everyone with the right
to alter particular fields in the table.
I suspect the former but this may give me thousands (Or even more) mysql
users - it is a very popular guestbook. Is this normal? Is their a limit
on the
amount of users?
Please let me know if I have got this all wrong :)
Thanks in advance for your time
Darren Smith
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
