On 4/5/06, NiCK Song <[EMAIL PROTECTED]> 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: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
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 -----BEGIN GEEK CODE BLOCK----- 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++ ------END GEEK CODE BLOCK------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
