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 ) 4  14043 
hopefully not, that would be a large security hole!
Jim
"Robert Kattke" <in*****@rcn.co m> wrote in message
news:cf******** *************** ***@posting.goo gle.com... 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 )
hopefully not, that would be a large security hole!
Jim
"Robert Kattke" <in*****@rcn.co m> wrote in message
news:cf******** *************** ***@posting.goo gle.com... 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 ) in*****@rcn.com (Robert Kattke) wrote in
news:cf******** *************** ***@posting.goo gle.com: 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 in*****@rcn.com (Robert Kattke) wrote in
news:cf******** *************** ***@posting.goo gle.com: 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 shows all current backups, and restores the
selected one with one click...
|
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 created the user to access the database,
and gave all privs with grant option for that database. But when I go to
run the command to restore the database, I get the following error:
$ mysql -u user -p database < database.sql
Enter password:
|
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 version of this document can be found at:
http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download
|
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 constraints defined in the create
statement of each table. These foreign key constraints are violated at the
time of restore. We have tried the following two solutions...
(1) We have tried to backup the database tables in the order of their
dependencies....
|
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
I did. It did not work. Here's the error:
/usr/bin/mysqladmin: connect to server at 'appserver' failed
error: 'Host 'appserver.crci.com' is not allowed to connect to this
MySQL server'
Another command I'm supposed to run also resulted in an...
| | |
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 server) and
try to restore their my finance db:
mysqldump -u root --password=111 finance2 < sqlbk.dump
|
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 through this without much trouble. Programming knowledge is not required.
Index
What is SQL?
Why MySQL?
Installing MySQL.
Using the MySQL command line interface
|
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 1.5..
i have created a form bean to get the data from the user.
then in my action class i m trying to get a database connection and adding the values of the user. and i also wanna show them back to him.
its a dummy project for my learning(to get...
|
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
when i run this query :
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
