Questions tagged [password-recovery]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
172 views

How to change password expire duration in the alter user statement in Oracle?

I'm working with a 19c Oracle database. We usually reset passwords for users and set temporary ones by using the password expire option with the alter user statement. The issue I'm going through is ...
Humberto Castellon's user avatar
0 votes
2 answers
475 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 ...
Dean's user avatar
  • 21
-1 votes
1 answer
307 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: ...
Hassan's user avatar
  • 1
0 votes
1 answer
356 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)
Kwabena's user avatar
0 votes
0 answers
607 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 ...
Frank Martin's user avatar
0 votes
2 answers
414 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 ...
user151976's user avatar
1 vote
0 answers
867 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 ...
Rauf Asadov's user avatar
  • 1,253
1 vote
1 answer
5k 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 ...
K Pekosh's user avatar
  • 111
1 vote
2 answers
3k 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/...
Chathura Buddhika's user avatar
4 votes
2 answers
6k 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 ...
Evan Carroll's user avatar
  • 62.1k
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 ...
eekfonky's user avatar
  • 207
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 $...
Evan Carroll's user avatar
  • 62.1k
0 votes
1 answer
632 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 ...
user avatar
8 votes
1 answer
5k 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 ...
retif's user avatar
  • 427
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, ...
Dylon's user avatar
  • 23
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 ...
user avatar
2 votes
3 answers
845 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 ...
John T.'s user avatar
  • 21
0 votes
3 answers
17k 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 ...
user34025's user avatar
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 ...
user1866880's user avatar
41 votes
3 answers
202k 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 ...
AKIWEB's user avatar
  • 605
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 ...
vaheeds's user avatar
  • 131
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 ...
Tom's user avatar
  • 267
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 ...
nigellaw's user avatar
  • 133
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 ...
Ajit S's user avatar
  • 187
17 votes
1 answer
113k 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 ...
Jonas's user avatar
  • 32.6k