List:General Discussion« Previous MessageNext Message »
From:Daniel da Veiga Date:April 5 2006 6:43pm
Subject:Re: Password expire?
View as plain text  
On 4/5/06, NiCK Song <songnick@stripped> wrote:
> Hi, experts
> How can I make mysql database users password with expire date?
> Does mysql can do  it?
> --
> NiCK
> --
> MySQL General Mailing List
> For list archives:
> To unsubscribe:

I guess you'll have to build it in your app. MySQL doesn't support
anything like this (or at least I couldn't find it).

I use a method like this:

My server has TWO accounts, when the user logs on my app with its
name/password, PHP connects using a read-only account to check if the
name/pass is valid accourding to a table named "users" at the "test"
database, and it also checks a datetime value named "expire" at the
same table, if the password is no longer valid, PHP denies access,
else it makes another connection, this time with an account with
read-write privileges so the user is logged into the app.

Daniel da Veiga
Computer Operator - RS - Brazil
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
Password expire?NiCK Song5 Apr
  • Re: Password expire?Barry5 Apr
  • Re: Password expire?SGreen5 Apr
  • Re: Password expire?Daniel da Veiga5 Apr