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/[
"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
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
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]