>>>>> "Van" == Van <vanboers@stripped> writes:
Van> I'm using a PHP-enabled application to maintain time-billing information
Van> for my company. Many of these people will be first-time users of a
Van> web-enabled application. I'm trying to set it up, so the first time they
Van> try to log in, it gives them the option of having their password mailed to
Van> them. (They already have a UNIX account). I'll generate a random
Van> password for their username, and mail it to them.
Van> When they return, I want to give them the ability to change their
Van> password. Is their a way to do this on a per row basis in 3.22.21? I
Van> don't recall seeing that when I installed it.
Van> My other option is to create a separate database and put very tight
Van> programming around it so they can only access their own user information
Van> without being able to affect other peoples' user information. My concern
Van> with this approach, is I'm bringing in a couple database programmers very
Van> green, who understand dba to some degree, but not MySQL dba (grants, and
Van> so forth). This is also the reason I want to keep user administration out
Van> of the native MySQL user table until per row security becomes available.
Van> Thanks in advance for any ideas on this. I'll post the application once
Van> it's complete to a public ftp site.
Van> Linux rocks!!! www.dedserius.com
With MySQL 3.22.21, any user can change his password with the
'mysqladmin password new_password'