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(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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 manually on a schedule you want to set.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

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

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]