Re: Password expire?

2006-04-05 Thread Daniel da Veiga
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/[

Re: Password expire?

2006-04-05 Thread SGreen
"NiCK Song" <[EMAIL PROTECTED]> wrote on 04/04/2006 11:05:57 PM: > Hi, experts > > How can I make mysql database users password with expire date? > Does mysql can do it? > > -- > NiCK > Sorry!! MySQL does not auto-expire any user accounts. You will need to script something to do that manuall

Re: Password expire?

2006-04-05 Thread Barry
NiCK Song wrote: Hi, experts How can I make mysql database users password with expire date? Does mysql can do it? -- NiCK Set a DATE field with the time of expire. Then do something like SELECT * FROM users WHERE datefield_of_insert > CURDATE(); HTH Barry -- Smileys rule (cX.x)C --o

Password expire?

2006-04-04 Thread NiCK Song
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]