Can you retrieve/restore a MySQL user Password ?

Subject: Can you retrieve/restore a MySQL user Password ?

I'm working on my own, local WXP, MySQL, version: 3.23.38-nt
and I have the "root" password, and normally use the root account.

I have forgotten one of the Passwords for a user account which I have
set up. Is there any way to UnEncrypt the users password, so I can
use that account again ? Any handy function that the "root" account
can use, to determine a user's password ?
OR
Should I delete the account and start from scratch ?
OR
Should I re-apply GRANT statements so as to reset user/pass info ?

TIA for your suggestions. -R ( invinfo@rcn.com )

re: Can you retrieve/restore a MySQL user Password ?

hopefully not, that would be a large security hole!
Jim
"Robert Kattke" <invinfo@rcn.com> wrote in message
news:cfa6f14f.0310220727.60edbe0d@posting.google.c om...[color=blue]
> Subject: Can you retrieve/restore a MySQL user Password ?
>
> I'm working on my own, local WXP, MySQL, version: 3.23.38-nt
> and I have the "root" password, and normally use the root account.
>
> I have forgotten one of the Passwords for a user account which I have
> set up. Is there any way to UnEncrypt the users password, so I can
> use that account again ? Any handy function that the "root" account
> can use, to determine a user's password ?
> OR
> Should I delete the account and start from scratch ?
> OR
> Should I re-apply GRANT statements so as to reset user/pass info ?
>
> TIA for your suggestions. -R ( invinfo@rcn.com )[/color]

re: Can you retrieve/restore a MySQL user Password ?

hopefully not, that would be a large security hole!
Jim
"Robert Kattke" <invinfo@rcn.com> wrote in message
news:cfa6f14f.0310220727.60edbe0d@posting.google.c om...[color=blue]
> Subject: Can you retrieve/restore a MySQL user Password ?
>
> I'm working on my own, local WXP, MySQL, version: 3.23.38-nt
> and I have the "root" password, and normally use the root account.
>
> I have forgotten one of the Passwords for a user account which I have
> set up. Is there any way to UnEncrypt the users password, so I can
> use that account again ? Any handy function that the "root" account
> can use, to determine a user's password ?
> OR
> Should I delete the account and start from scratch ?
> OR
> Should I re-apply GRANT statements so as to reset user/pass info ?
>
> TIA for your suggestions. -R ( invinfo@rcn.com )[/color]

re: Can you retrieve/restore a MySQL user Password ?

invinfo@rcn.com (Robert Kattke) wrote in
news:cfa6f14f.0310220727.60edbe0d@posting.google.c om:
[color=blue]
> Subject: Can you retrieve/restore a MySQL user Password ?
>
> I'm working on my own, local WXP, MySQL, version: 3.23.38-nt
> and I have the "root" password, and normally use the root account.
>
> I have forgotten one of the Passwords for a user account which I have
> set up. Is there any way to UnEncrypt the users password,[/color]

That would be bad security.
[color=blue]
> so I can use that account again ?
>[/color]

Check out if the database management user (root?) have the possibility to
give the user a new password. Then the user can change it to whatewer
(s)he want later.

--
Rolf Østvik

re: Can you retrieve/restore a MySQL user Password ?

invinfo@rcn.com (Robert Kattke) wrote in
news:cfa6f14f.0310220727.60edbe0d@posting.google.c om:
[color=blue]
> Subject: Can you retrieve/restore a MySQL user Password ?
>
> I'm working on my own, local WXP, MySQL, version: 3.23.38-nt
> and I have the "root" password, and normally use the root account.
>
> I have forgotten one of the Passwords for a user account which I have
> set up. Is there any way to UnEncrypt the users password,[/color]

That would be bad security.
[color=blue]
> so I can use that account again ?
>[/color]

Check out if the database management user (root?) have the possibility to
give the user a new password. Then the user can change it to whatewer
(s)he want later.

--
Rolf Østvik