At 11:41 -0400 10/11/04, Jerry Swanson wrote:
I create table and used password
// CHAR(15)
select password('123456');
++
| password('123456') |
++
| 565491d704013245 |
++
//INT(10)
+-+
| password|
+--
Thanks all, it helped me a lot
Manisha
- Original Message -
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "Nitin" <[EMAIL PROTECTED]>; "Manisha Sathe"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 16,
t;
Sent: Thursday, October 16, 2003 16:13
Subject: Re: PASSWORD() function problem
> all encryption functions are one way only
>
> Nitin
>
> - Original Message -
> From: "Manisha Sathe" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
>
"Manisha Sathe" <[EMAIL PROTECTED]> wrote:
> thanks all, it works (i just increase it to 20)
Please, don't use PASSWORD() function in your own application, use MD5() or SHA1()
instead.
> but one more thing, now if i want to get this password (e.g for option
> forget password), can we retrieve, i
-
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 15:16
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase it to 20)
> but one more thing, now if i want to get this password (e.g
all encryption functions are one way only
Nitin
- Original Message -
From: "Manisha Sathe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 6:46 PM
Subject: Re: PASSWORD() function problem
> thanks all, it works (i just increase
: "Manisha Sathe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 15, 2003 11:05 PM
Subject: Re: PASSWORD() function problem
> At 17:26 +0800 10/15/03, Manisha Sathe wrote:
> >Hi,
> >
> >I inserted one record thr PHPMyAdmin - mem_pass f
At 17:26 +0800 10/15/03, Manisha Sathe wrote:
Hi,
I inserted one record thr PHPMyAdmin - mem_pass field of member
table set to xyz using function 'PASSWORD'
Then trying to select the same - select * from member where mem_pass
= PASSWORD('xyz') - then it is not getting selected
I do not know w
On Wed, 15 Oct 2003 17:26:23 +0800
"Manisha Sathe" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I inserted one record thr PHPMyAdmin - mem_pass field of member table set to xyz
> using function 'PASSWORD'
>
> Then trying to select the same - select * from member where mem_pass =
> PASSWORD('xyz') - t
Yes, that's intentional - we have changed this in 4.1, but it's not
documented in the manual yet. A quote from the developer working on that
code:
So, the PASSWORD() function is now not to be used for passwords? The
problem is that I have built at least a few applications that use
PASSWORD() as
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 19 Dec 2002 [EMAIL PROTECTED] wrote:
> >Description:
> with the latest 4.1 tree (from today) the PASSWORD() function returns random
>alpha-numeric text /[a-f0-9]/
> 45 characters in length (which is too long for a password string)
On Thu, 2002-10-31 at 21:27, Elaine Kwek wrote:
> i hope someone can help me in my problem. I have use the password function
> in mysql to encrypt a string. Then when i try to get the encrypted password
> using php and compare with the password that user enter. although the user
> provide the corre
You can't decrypt the password from MySQL, instead, you should encrypt the
input from PHP and then do the string comparison.
Good Luck,
Dennis
- Original Message -
From: "Elaine Kwek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 9:27 PM
Subject: password f
Use the PASSWORD() MySQL builtin function as follows:
INSERT INTO Table
VALUES ('0', 'username', PASSWORD('password'), 'email')
This function is not part of the SQL standard. It is
used for storing passwords in the MySQL user table in
the mysql database schema named mysql among other things.
N
You need to use PASSWORD() function..
INSERT INTO table VALUES('0', 'username', PASSWORD('passwd'), 'email');
See: http://mysql.com/doc/M/i/Miscellaneous_functions.html
Gurhan
-Original Message-
From: Jule [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 12, 2002 8:37 PM
To: [EMAIL PROTECT
Im going to take a shot in the dark since I have not messed with ASP in
years
Have you just tried to verify the data is there with a simpler script?
Just do the connection script then the user_check then see if it is
still there. If it was PHP I would be able to find it.
-Original Messa
From: Lee, Andrew <[EMAIL PROTECTED]>
> If user_id and passwd are fields in your table and the passwd field is
> encrypted :
> SELECT user_id FROM user WHERE passwd = PASSWORD('plaintext_user_pass')
Woops, I was typing too fast Ramiro. Andrew's query is right and mine is wrong.
---
Rodney Broom
From: Kenneth Hylton <[EMAIL PROTECTED]>
> Basically, if you encrypt the password, then you have to look it up using
> the password function, too.
What he means is this:
SELECT user_id FROM user WHERE PASSWORD(user_pass) = PASSWORD('my_var')
---
Rodney Broom
Programmer: Desert.Net
sql
--
--- Ramiro Varandas Jr <[EMAIL PROTECTED]>
wrote:
> I think that this question might be kinda of stupid
> for all of you but I
> couldn't find a good answer... When we use the MySQL
> internal function -
> Password('string') - MySQL inserts that string
> codified into the database, so
> that
If user_id and passwd are fields in your table and the passwd field is
encrypted :
SELECT user_id FROM user WHERE passwd = PASSWORD('plaintext_user_pass')
> -Original Message-
> From: Ramiro Varandas Jr [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 11:49 AM
> To: [EMAIL PRO
Okay, here's a hint...
4.2.9 in the manual (;o)
Basically, if you encrypt the password, then you have to look it up using
the password function, too.
Ken Hylton
Programmer Analyst IV
LEC Systems & Programming
Billing Concepts, Inc.
7411 John Smith Drive
San Antonio, Texas 78229-4898
(210) 949
It works fine for me.
How big is your password field in the table? It should be: char(16)
-Original Message-
From: Jose Alvarez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 11:35 AM
To: [EMAIL PROTECTED]
Subject: PASSWORD function
Dear friends, I am quite new to MySql
riginal Message -
From: "Fred van Engen" <[EMAIL PROTECTED]>
To: "Kevin Williams" <[EMAIL PROTECTED]>; "MySQL Mailing
List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 6:06 AM
Subject: Re: Password function
> Hi Kevin,
>
> On Tue, Mar 2
well, as easy as is: store the original password, or use a php/your
programming_language_specific function like encrypt() and decrypt().
password function is (and should be) irreversable, like a md5 hash. that's
where it's ment for.
- Original Message -
From: "Kevin Williams" <[EMAIL PRO
You can't. You'll have to regenerate a new, random password and send that
out.
- Original Message -
From: "Kevin Williams" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 7:27 AM
Subject: Password function
Peeps,
My problem is this. I'm
Hi Kevin,
On Tue, Mar 27, 2001 at 02:27:55PM +0100, Kevin Williams wrote:
> Peeps,
>
> My problem is this. I'm not happy about storing plain text passwords in my database
>for users, so was considering using the password () function in order to store a hash
>of the password instead.
>
> sampl
Look up skip grants in the manual.
- Original Message -
From: "root" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 16:09
Subject: password() function not used when creating root password
> I have just created a root password in MySQL without using the PASS
27 matches
Mail list logo
