473,320 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 ( in*****@rcn.com )
Jul 19 '05 #1
4 14014
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: James | last post by:
HI, I'm looking for a script that will allow users/admins to have a one click backup solution for a MYSQL Database.. 'BACK DATABASE' button, click and its done... The a restore option, that...
0
by: Carl B. Constantine | last post by:
I'm trying to move a database from one machine to another. I dumped the database and successfully loaded it on one machine, but I can't do it on another machine. I have the database set up. I...
0
by: Mike Chirico | last post by:
Interesting Things to Know about MySQL Mike Chirico (mchirico@users.sourceforge.net) Copyright (GPU Free Documentation License) 2004 Last Updated: Mon Jun 7 10:37:28 EDT 2004 The latest...
1
by: Rajesh Kapur | last post by:
Hello, We are on MySQL 4.0.21 on linux. We use InnoDB tables and foreign key constraints extensively. The mysqldump backs up the database tables in alphabetical order with foreign key...
5
by: MLH | last post by:
I'm supposed to set a password for the MySQL root user. The output of mysql_install_db instructed me to run the following commands... /usr/bin/mysqladmin -u root -h appserver password mynwewpasswd...
2
by: Vadim | last post by:
Hi! I succesfully exported my locally stored db using the following syntax: mysqldump -u root --password=111 finance > sqlbk.dump Now I created another empty db finance2 (on the same Mysql...
6
Atli
by: Atli | last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users. Anyone should be able to get...
9
by: gavy7210 | last post by:
hello friends i am new to struts. i want to add the user information in the database and then display it back to him. i am using struts 1.2,Eclipse Platform Version: 3.4.2,mySql 5.0.1,jdk...
2
by: santhanalakshmi | last post by:
Hi, Please help me out..... I have created an user in the Mysql database with the password. user : san password : san ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.