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|
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 field of member
table set to xyz using function 'PASSWORD'
Then trying
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 it to 20)
but one more thing, now
-
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 for option
forget password), can we
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
Subject: Re: PASSWORD() function problem
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
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, 2003 10:56 PM
Subject: Re: PASSWORD() function problem
Hi,
If I
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') - then it is
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
-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).
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
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
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.
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)
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
--- 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 people
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
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
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
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
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 PASSWORD
21 matches
Mail list logo