Questions tagged [password-recovery]
The password-recovery tag has no usage guidance.
26 questions
1
vote
0
answers
88
views
MySQL root password reset
I've spent many an hour trying to reset my mysql root password with no luck.
I'm running an up to date patched Ubuntu server 22.04.4 with mysql 8.0.36.
My latest attempt is using
sudo mysqld_safe --...
0
votes
2
answers
315
views
How to list available users in PostgreSQL having only the data directory?
I messed up a bit with a Dockerized PostgreSQL instance and accidentally overwrote the values I had for POSTGRES_USER and POSTGRES_PASSWORD. They were randomly generated, so guessing them is basically ...
0
votes
2
answers
709
views
Can SQL Server log a password on a failed login attempt?
I'm trying to recover a hard-coded password for SQL Server from an old VB6 application. Is there any way to get MS SQL Server to record the passwords used when a login attempt fails?
I've checked the ...
-1
votes
1
answer
357
views
Reset password Oracle database 18c [duplicate]
I have installed Oracle databases 18c. I forgot the account administrator of the databases, how to recover the password?
SP2-0640: Not connected
SQL> conn XEPDB1
Enter password:
ERROR:
ORA-01017: ...
-1
votes
1
answer
434
views
Cannot log in to the MySQL server
Cannot log in to the MySQL server they say mysqli::real_connect(): (HY000/1045): Access denied for user 'Stephen Ankoh'@'localhost' (using password: YES)
0
votes
0
answers
697
views
Syntax error when update root password
I forgot MySQL root password so I am trying to change it by starting it in safe mode and running following command but getting syntax error. MySQL version is 8. What is the correct syntax to update ...
0
votes
2
answers
587
views
Migrate unknown Oracle database user's encrypted password - 11g hash to 12c database
I have tried to search extensively but could not find.Oracle has changed the encryption (spare4) in 12c.
I am trying to see if its possible to migrate / copy the encrypted password hash of a user in ...
1
vote
0
answers
937
views
Is it possible to reset SA password without stopping SQL Server Service?
I lost a password for sa account. Now I want to reset SA password and at the same time not to restart SQL Server Service or going into single-user mode. I would like to mention that I am windows ...
1
vote
1
answer
6k
views
ALTER USER postgres PASSWORD null; now has locked me out of psql
I have installed postgresql version 9.3.14 on High Sierra via HomeBrew. Upon trying to access the server via psql, I was being prompted for a password for the user postgres. Using postgres as the ...
1
vote
2
answers
4k
views
Cannot reset MySQL default root password after initial installation
I have installed mysql 5.7 on a Red Hat Enterprise Linux 5.5 server and when I tried to run following command after installation it is asking for a password for root@localhost.
/usr/bin/...
4
votes
2
answers
7k
views
How do I reset the SQL Server password on Linux?
The instructions on technet say that I either have to reset the SQL Server configuration with mssql-conf setup or run a proc which I can not run because I do not have access.
What the simplest way to ...
2
votes
1
answer
1k
views
Reset MongoDB root Password on Amazon Linux
I have inherited a MongoDB and no one knows the root password. Is there a way to change it? I am running MongoDB shell version: 3.2.17.
I would like to back up the DB's but need access to see what's ...
1
vote
1
answer
1k
views
Can not reset MariaDB password "can't connect to local MySQL server through socket"
When I go
mysqld_safe --skip-grant-tables &
This message is outputted.
170802 14:14:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
When I try to run mariadb, I get
$...
0
votes
1
answer
651
views
Recover lost MySQL password
I hate to ask a stupid question like forgetting the password, but this one is really hard to get back. Tried all the methods I can find online, and none is working. Even deleting the database requires ...
8
votes
1
answer
6k
views
Install MySQL for Windows from .zip and reset root password
I wanted to have on my PC (with Windows 8.1 x64) the MySQL server only, without Workbench or something. So I downloaded .zip archive from dev.mysql.com/downloads. It's a download for Win64 on x86_64 ...
1
vote
1
answer
3k
views
Lost DMK encryption password for master database
Back story:
My company has TDE encryption enabled for some of our databases. The password that the master key was encrypted by for one of our servers is lost. We do have the backup .key file, however, ...
0
votes
2
answers
4k
views
Oracle sys password lost
I inherited an Oracle DB on Linux Redhat from someone who left the company and didn't tell anyone what the passwords were to the various accounts on the database itself (not Linux), including what he ...
2
votes
3
answers
879
views
Reset of root password not working?
Our previous DBA left and didn't note the root password down, and I've been pressganged into doing part of his job until we can hire someone.
So I create a file :
/root/mysql.password
Inside that ...
0
votes
3
answers
18k
views
Displaying user's password [closed]
I need to know if there is a way in SQL*Plus to display the password of a certain username?
At my job, sometimes the developers ask me what happened to their account, and what their password is. When ...
1
vote
2
answers
3k
views
reset mysql root password on ubuntu
In short: my goal is to reset mysql root password on ubuntu.
Background: I set up a ubuntu desktop and installed LAMP stack last week. I then went to do something else, and just got back to carry on ...
42
votes
3
answers
210k
views
Forgotten PostgreSQL Windows password
This morning I’ve been trying to connect the PostgreSQL database on my Windows 7 Professional desktop.
The default value is ‘postgres’, but sure enough I forgot what password I used when I originally ...
2
votes
1
answer
4k
views
Cannot connect to SQL Server after setting sa password to blank
I have installed SQL Server 2008 R2 on a Windows 2008 server. I need to set the sa password to blank for some reasons to make an application works; but it seems like the password changes automatically ...
3
votes
3
answers
2k
views
How to forcibly create/modify MySQL user grants, without restarting the database service
I am familiar with how to start MySQL server with the "--init-file" option, or the "--skip-grant-tables" options.
However I have a nagios based mysql monitor, which needs to query a table, and ...
2
votes
1
answer
4k
views
Lost postgreSQL password in Windows installation [duplicate]
I have postgresql 9.2 installed on a windows XP machine. I have lost the postgres password.
I looked at answers given to a similar question asked 6 months ago. The answer given there required the ...
4
votes
2
answers
24k
views
Reset MySQL root password in LAMPP server on Ubuntu
I forgot the password I changed for the root user of MySQL. I'm logged in as root user and when I do
# /opt/lampp/lampp security
it gives result as
XAMPP: Quick security check...
XAMPP: Your XAMPP ...
17
votes
1
answer
118k
views
How do I reset the postgres password for PostgreSQL on Windows? [duplicate]
I have installed PostgreSQL on my Windows machine for development. Now I haven't used it for a while, and have forgotten the password for user postgres (default admin user in PostgreSQL). How can I ...