For passwords it is good to use the sql function password(). This is done
like this:
to insert:
insert into users ('username1234', password('userspassword') );
to load
select * from users where username='username1234' AND
password=password('userspassword')
Hope this helps.
ryan
Hi,
So
Ok, so you can obtain a random result (thought that was what random()
was for), but still cannot understand how this could be usefull. I use
encrypt to store password info in a database, but how do you compare the
user entered password with the one in the database if the results vary
the whole
Just use the password() function, which will return a nice 16-byte 1-way encrypted
string.
On Fri, 08 Jun 2001 00:04:18 -0700
Richard Ellerbrock [EMAIL PROTECTED] wrote:
Ok, so you can obtain a random result (thought that was what random()
was for), but still cannot understand how this could
Hi,
So where does mysql get its salt from? Is it a random salt?
This confused the hell our of me for around an hour!
You should look MySQL manual not C crypt manpage ;). And yes, this is
random salt and makes life little bit more secure.
Ok, so you can obtain a random result (thought
Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt
without specifying a salt yields random results:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1732533 to server version: 3.23.37-log
Type 'help;' or '\h' for help. Type
On Thu, 7 Jun 2001, Richard Ellerbrock wrote:
Looking at the encrypt function, it optionally takes a salt parameter. Using encrypt
without specifying a salt yields random results:
mysql select encrypt('qwerty');
+---+
| encrypt('qwerty') |
+---+
|