I had an encrypted password. I changed the encrypted
password as follows:
mysql>update user password=newpassword;
I immediately relised that I should have used the
following:
mysql>update user password=PASSWORD(newpassword);
I am can not now use MySQL which is locally installed
in m
However, I currently have a need to extract and decode that data. I need
a two way function.
Curtis
On Sun, 16 Feb 2003, Michael T. Babcock wrote:
> Curtis Maurand wrote:
>
> >need to encrypt data and then retrieve it later (credit card data). I could
> >probably pass it through and md5 or
Point well taken. I will do remotes that way.
Curtis
On Sun, 16 Feb 2003, Michael T. Babcock wrote:
> Curtis Maurand wrote:
>
> >need to encrypt data and then retrieve it later (credit card data). I could
> >probably pass it through and md5 or des function via openssl I suppose and
> >then
Curtis Maurand wrote:
need to encrypt data and then retrieve it later (credit card data). I could
probably pass it through and md5 or des function via openssl I suppose and
then store it. Perl and PHP both have functions to handle that.
Just to be a security nut, you shouldn't use the encry
I came to the same conclusion today after reading the docs again. I would
prefer the des_encode if I need to get things back out of it, but since I'm
running 3.23.55, the des_encode function is not available to me. I have a
need to encrypt data and then retrieve it later (credit card data). I
On Tue, 2003-02-11 at 15:39, Curtis Maurand wrote:
>
> The manual suggests that the password function is really for intenal mysql
> functions. Ideally you should use the encode or md5_encode functions.
>
> update user set password=encode('password', 'salt') where user =
> 'your_user';
>
Unle
Hi!
On Feb 04, Jianping Zhu wrote:
>
> I have mysql in a redhat machine. I need to use mysql do user
> authentication to a website.
> I have a table like following.
>
> +--+--+
> | username | passwd |
> +--+--+
> | jianping | jian1830 |
> | chichi | jian1830 |
The manual suggests that the password function is really for intenal mysql
functions. Ideally you should use the encode or md5_encode functions.
update user set password=encode('password', 'salt') where user =
'your_user';
Curtis
On Wed, 5 Feb 2003, Natale Babbo wrote:
> try to use the pas
> On Wed, 2003-02-05 at 13:53, Kamara Eric R-M wrote:
>
>> INSERT into tbl_name (username,password) values
>> ('user',PASSWORD('passwd'));
>>
>> and when authenticating the user you can do something like
>>
>> SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in
>> this case $pass i
When you store the information into the field you can us the mysql function
password. Then when you wish to test for a match you do something like
select count(*) where username='$username' and passwd = Password($password)
Where $username is the input username and $password is the input usernam
Try this:
insert into tablename values ('myusername', password('mypassword'));
[EMAIL PROTECTED] wrote:
On Tue, Feb 04, 2003 at 02:58:28PM -0500, Jianping Zhu wrote:
I have mysql in a redhat machine. I need to use mysql do user
authentication to a website.
I have a table like following.
On Wed, 2003-02-05 at 13:53, Kamara Eric R-M wrote:
> INSERT into tbl_name (username,password) values
> ('user',PASSWORD('passwd'));
>
> and when authenticating the user you can do something like
>
> SELECT username from tbl_name where passwd=PASSWORD('$pass'); and in this
> case $pass is the va
the easiest way to do this is to use mysql's own 'password' function.
to add a new user use:
insert into table (username,passwd) values ('jianping',password('jian1830'))
to validate the password:
select count(*) from table where username='jianping' and
passwd=password('whatwasentered');
or
On Tue, Feb 04, 2003 at 02:58:28PM -0500, Jianping Zhu wrote:
>
> I have mysql in a redhat machine. I need to use mysql do user
> authentication to a website.
> I have a table like following.
>
> +--+--+
> | username | passwd |
> +--+--+
> | jianping | jian1830 |
On Tue, 4 Feb 2003, Jianping Zhu wrote:
>
> I have mysql in a redhat machine. I need to use mysql do user
> authentication to a website.
> I have a table like following.
>
> +--+--+
> | username | passwd |
> +--+--+
> | jianping | jian1830 |
> | chichi | jian18
Hi,
Use the PASSWORD() function to encrypt the password.
There are other encryptation functions in MySQL like MD5(), SHA1(),
ENCRYPT(). Have a look at functions you can use in SELECT statement at
the manual.
http://www.mysql.com/doc/en/Miscellaneous_functions.html
On Tue, 2003-02-04 at 19:58, Jian
Hi,
Simply do the following:
INSERT INTO yourtable (username, password)
VALUES ('chichi', PASSWORD('jian1830'));
The encrypted password will look like this... 2748c558120ee3c9. This is
MySQL's own internal encrypting function.
Remember to set the password to a, CHAR(1
- Original Message -
From: "Jianping Zhu" <[EMAIL PROTECTED]>
Sent: Tuesday, February 04, 2003 1:58 PM
> I want the passwd field not to be plain text but encrypted. how can i do
> that?
Use the password function:
mysql> create table users (
-> name varchar(12),
-> pass varchar(1
try to use the password() function.
update user set password=password('your_psw') where
user='your_user'
bye
--- Jianping Zhu <[EMAIL PROTECTED]> ha scritto: >
> I have mysql in a redhat machine. I need to use
> mysql do user
> authentication to a website.
> I have a table like following.
>
I have mysql in a redhat machine. I need to use mysql do user
authentication to a website.
I have a table like following.
+--+--+
| username | passwd |
+--+--+
| jianping | jian1830 |
| chichi | jian1830 |
+--+--+
I want the passwd field not to
20 matches
Mail list logo