By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,492 Members | 3,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,492 IT Pros & Developers. It's quick & easy.

Can you retrieve/restore a MySQL user Password ?

P: n/a
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 ( in*****@rcn.com )
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
hopefully not, that would be a large security hole!
Jim
"Robert Kattke" <in*****@rcn.com> wrote in message
news:cf**************************@posting.google.c om...
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 ( in*****@rcn.com )

Jul 19 '05 #2

P: n/a
hopefully not, that would be a large security hole!
Jim
"Robert Kattke" <in*****@rcn.com> wrote in message
news:cf**************************@posting.google.c om...
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 ( in*****@rcn.com )

Jul 19 '05 #3

P: n/a
in*****@rcn.com (Robert Kattke) wrote in
news:cf**************************@posting.google.c om:
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,
That would be bad security.
so I can use that account again ?


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
Jul 19 '05 #4

P: n/a
in*****@rcn.com (Robert Kattke) wrote in
news:cf**************************@posting.google.c om:
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,
That would be bad security.
so I can use that account again ?


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
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.