/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]>
>
AIL PROTECTED]>
To: "[EMAIL 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 ne
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 t
+
| password|
+-+
| 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
|
When I used char(15) the data was not complete.
What data type I should use for password function?
TH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
> for
-
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
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 me
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
PAS
-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
>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
>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).
exam
On Friday, November 1, 2002, at 05:39 PM, [EMAIL PROTECTED] wrote:
Hi,
Hello.
I'm new to mysql and I'm reading a pdf book on how to change the
default
password for admin to my own choosing.
The problem is once I do the steps of -password mypass it comes back
with
an error message.
Try to do
Hi, I'm new to mysql and I'm reading a pdf book on how to change the default
password for admin to my own choosing.
The problem is once I do the steps of -password mypass it comes back with
an error message.
I'm not for sure what the message is because I'm at work now and its on my
home machine.
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
>
2 9:27 PM
Subject: password function
> 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 cor
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 correct password, but then the comparetion still fail. So
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
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
* 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
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.
> M
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 qu
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 encryp
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
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:
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 |
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 Connec
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
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
Progr
--- 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
9 AM
> To: [EMAIL 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
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-
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 h
ncrypted passwords, so I need to write something that
> hashes the password 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
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
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 rea
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 sql/pass
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
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
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 authentificat
I'm going to jump in here and give a little more information.
The password() function is in fact a one way encryption. For a two way
encryption use the encode() function. But beware, any data stored with the
encode() function is only as secure as the master password you assign it.
You c
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 Wi
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
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
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.
sample SQL.
$sql = "SELECT login,IPaddress,password,administrator,va
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 i
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
55 matches
Mail list logo
