RE: [PHP-DB] newbie - correct use of Grant in mysql

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:dagza@dagza.fsnet.co.uk] Sent: Tuesday, August 28, 2001 5:12 AM To: php-db@lists.php.net 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 dagza@email.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net