Re: Password protection
Jeremy Zawodny wrote: On Mon, Dec 23, 2002 at 03:53:14PM -0700, Mark Stringham wrote: I know the MySQL password( ) function is irreversible. I have also been told that storing passwords in plain text is a bad idea. Can a get a few suggestions of good ways to store passwords in the db? Using MD5() is one of my favorite alternatives. Jeremy The way many systems handle passwords, is that you store the password as a one-way encryption (MD5 or crypt() for example), then when you need to test if that is the right password, you encrypt the password they give you, then see if the two encrypted forms match. That system makes breaking passwords much harder, since you have to brute force, not just have the reverse encryption key and then have access to all of the passwords. -- Kevin - 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
Re: configuring MySQL
[EMAIL PROTECTED] wrote: Ok, I finally got a src version of MySQL that worked. Now, i've got another problem. I FINALLY found this "termcap" library, I guess it's part of Emacs. SO, I installed Emacs. I even checked that termcap.c was in the /src directory. Now, I still get this error when configuring MySQL: "checking for termcap functions library... configure: error: No curses/termcap library found" p.s. I'm using 3.23.51 (all the .54 srces I found dont work) Depending on your linux distro (assuming you are using linux), you need to either find the package or compile the source for the ncurses library. On Debian, this would be something like, libncurses5-dev. termcap is a rather obsolete method for doing console screen functions, it is the ncurses library that you need to find and install, one way or another. -- Kevin - 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
Re: Another Rank Amateur Question
Stephen Tiano wrote: [snip] LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; and I was greeted with: ERROR 1148: The used command is not allowed with this MySQL version There has to be a way to load data into tables as far back as the ancient 3.__. Could anyone share with me what the correct command/syntax is for pre-version 4? You will have to recompile mysql with the explicit option to enable that in the configure. -- Kevin Thank you. Steve Tiano - 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