Re: Record old passwords ?
I'm still pretty new on the list, so take it easy on me if I'm way off base. But I think you'd be better off with a table just for old passwords. I think you could get by with four columns: id(primary key), user_id, old_pw, change_date. It should make your validation query and inserts much easier. You could simply select * from oldpwtbl where user_id='theuser' order by change_date desc limit 4; (disregard my poor syntax) to see if they are repeating. One other thing I think would be more secure is to store a hash of the password, instead of the password itself. Anyway, that's my input. Scott On Mon, Jan 18, 2010 at 12:34 PM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi I'm in the process of designing a login system to a secure web page using MySQL. One of the features is we need to record and ensure that the user password is different from any of the last four passwords he/she has used. I was thinking of create four fields called Password1, Password2, Password3 and Password4 to record the old passwords. Is this a preferred method - or does anyone else have any recommendations ? Thanks, Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
submit a full bug report
I use kernel 2.4.9 ,I compiled mysql-3.23.41(./configure --with-low-memory; make ), when make, it said : ranlib .libs/libmysqlclient.a creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/usr/src/mysql-3.23.41/libmysql' Making all in client make[2]: Entering directory `/usr/src/mysql-3.23.41/client' c++ -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c mysql.cc mysql.cc: In function `void print_field_types (MYSQL_RES *)': mysql.cc:1539: Internal error: Segmentation fault. Please submit a full bug report. See URL:http://bugzilla.redhat.com/bugzilla/ for instructions. make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/usr/src/mysql-3.23.41/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-3.23.41' make: *** [all-recursive-am] Error 2 -- sailer-sh [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(+) Help needed
Ok I need help with this.. I have to values like $dat1="2001-01-11"; $dat2="2001-02-12"; so and i have Mysql table with IP | Size | Date| -- 213.32.44.11 | 3|2001-01-11-12| -- 213.32.44.11 | 3|2001-01-11-13| -- 213.32.44.12 | 3|2001-01-12-12| -- 213.32.44.14 | 3|2001-01-13-17| -- 213.32.44.16 | 3|2001-01-14-11| -- 213.32.44.111 | 3|2001-02-15-10| -- 213.32.44.121 | 3|2001-01-13-10| -- 213.32.44.131 | 3|2001-01-15-10| -- So i need SELECT from table only record between values $dat1 and $dat2 how to do this ?! Thx _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(+)Help
I have two mysql server with same tables how can i synch. this tables i'm mean if one table is updated second table is updated too !? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Help
Ok I need help So i have table with primary key ID, it's fills with something like 1,2,4,5 So and i have another table in which i would like to put data from first table from row ID how to do this || || | test1 | | test2 | || || | ID | | Cus_ID | | name | | aaa| | bla| | aaa1 | || || in this table ID - primary key datas from ID in table test1 must be inserted into test2 in row Cus_ID How to do this ?! _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php