I just upgrade my MySQL from 4.0.20 to 4.1.7, however
i found new things here, password() function
in 4.0.20 - password(xxx) result in 5336eb751494bdb1
in 4.1.7 - password(xxx) result in *3E5287812B7D1F947439AC45E739353
how to get backward compatibility for this function ? since i use
password
PROTECTED] [EMAIL PROTECTED]
CC:
Subject: Different password() function ?
Sent: Fri, 03 Dec 2004 10:01:06 GMT
Received: Fri, 03 Dec 2004 09:51:54 GMT
Read: Fri, 03 Dec 2004 09:57:47 GMT
I just upgrade my MySQL from 4.0.20 to 4.1.7, however
i found new things here, password() function
in 4.0.20
/mycon
http://www.scibit.com/products/mysqlcomponents
http://www.scibit.com/products/mysqlx
http://www.scibit.com/products/mascon
-Original Message-
From: Ady Wicaksono [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
CC:
Subject: Different password() function ?
Sent: Fri
|
+-+
| 565491d70401324 |
When I used char(15) the data was not complete.
What data type I should use for password function?
Actually, you should use a different function than PASSWORD(), which
should be used only in connection with account information in the
grant tables in the mysql database. SHA
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
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 why I am not getting the result. please help
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
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). The string
always starts with a * (asterisk).
example
Description:
The password function does not work as intended with latest 4.1 tree
(today's). It returns a string of LENGTH() = 45 starting with a *
(asterisk) and 44 alphanumeric characters /[a-z0-9]/
How-To-Repeat:
Using latest 4.1 BK tree, SELECT PASSWORD('something');
Fix:
Not known
of course, the safe way is to always reset the password when such a
thing happens.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Encrypting with PASSWORD() function
Walter,
Tuesday, May
Hi,
I am trying Mysql Password() function, to encrypt password in a a
user/password
table,
it works fine both ways; it is to say, when I submit a login
(user/password)
combination it fetches the pair ok.
My question is, as I read in the documentation, that the process is
irreversible, how
Hi Walter
My question is, as I read in the documentation, that the process is
irreversible, how can I deal with the fact
that a user can forget his password, if I will not be able to retrieve the
original string, because what i can see is the encrypted data
The purpose of the encrypted
Hi Walter,
Walter D. Funk wrote:
Hi,
I am trying Mysql Password() function, to encrypt password in a a
user/password
table,
it works fine both ways; it is to say, when I submit a login
(user/password)
combination it fetches the pair ok.
My question is, as I read in the documentation
At 10:59 -0300 5/14/02, Walter D. Funk wrote:
Hi,
I am trying Mysql Password() function, to encrypt password in a a
user/password
table,
it works fine both ways; it is to say, when I submit a login
(user/password)
combination it fetches the pair ok.
My question is, as I read
* Walter D. Funk
I am trying Mysql Password() function, to encrypt password in a a
user/password table,
it works fine both ways; it is to say, when I submit a login
(user/password) combination it fetches the pair ok.
My question is, as I read in the documentation, that the process
Walter,
Tuesday, May 14, 2002, 4:59:15 PM, you wrote:
WDF I am trying Mysql Password() function, to encrypt password in a a
WDF user/password
WDF table,
WDF it works fine both ways; it is to say, when I submit a login
WDF (user/password)
WDF combination it fetches the pair ok.
WDF My question
Hey guys and gals,
How do i add info to a table, and give a varchar(16) row the function of
password, so that it is encrypted? my query now is:
INSERT into table values('0', 'username', 'password', 'email')
thanks
Jule
--
|\/\__/\/|
| Jule Slootbeek |
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.
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 that look for that doesn't know the real password. But i
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
PROTECTED]
Subject: Password function
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 that look
--- 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
I thank all the people that helped me... was very usefull, I tried each one...
But i'm using ASP with a DSN Connection
Check the code:
Set MyConnection = Server.CreateObject(ADODB.Connection)
MyConnInfo = DSN=MyDSN;UID=MyUser;PWD=MyPass;
MyConnection.Open MyConnInfo
SQL = INSERT INTO user
Message-
From: Ramiro Varandas Jr [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 1:28 PM
To: [EMAIL PROTECTED]
Subject: Password function still doesn't working
I thank all the people that helped me... was very usefull, I tried each
one...
But i'm using ASP with a DSN Connection
Check
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
Can anyone tell me what algorithm PASSWORD uses? The reason I ask is
that we're trying
In the last episode (Jan 29), John Kemp said:
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
The algorithm is in the
John Kemp writes:
Hi all,
I can't find a description of the algorithm used in the mySQL PASSWROD
function. I understand it's a hashing algorithm of some kind, but I
don't know which algorithm (and I suspect it's *not* MD5.)
Can anyone tell me what algorithm PASSWORD uses? The reason I
I think mysql uses the system crypt() function. This is, no-doubt, available
through some well hidden Java class. Just do man crypt to learn about
crypt().
Chris
On Tue, 29 Jan 2002 10:59:55 -0500
John Kemp [EMAIL PROTECTED] wrote:
Hi all,
I can't find a description of the algorithm used
entered in the same way MySQL hashes a password (or
abandon the use of servlet auth :-)
Any clues?
How about using the PASSWORD function directly?
SELECT PASSWORD('thepassword'), Password
FROM user
WHERE User='username';
-- if they match, the unencrypted password matches.
Alternatively
Dear friends, I am quite new to MySql and database
development in general. I am doing my first db ever. I
came across a problem following the instructios in teh
book beginning PHP4 by Wankyu et al., Wrox.
The exercise is to create a user table, contaning user
id?s and passwords. The
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
I have just created a root password in MySQL without using the PASSWORD
function.
In the user table i put in a root password, like this.
mysql UPDATE user SET Password='new_password' WHERE user='root';
mysql FLUSH PRIVILEGES;
Now i am denied access. How do start the mysql server now
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 th
44 matches
Mail list logo