Re: Password protection

2002-12-23 Thread Kevin Mihelich
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

2003-01-03 Thread Kevin Mihelich
[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

2003-01-20 Thread Kevin Mihelich
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