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,
>
> > >
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 (
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 co
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 tim
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') |
> +---+
> |
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
