Questions tagged [password-recovery]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
1k 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
1answer
776 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/...
1
vote
2answers
2k 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 ...
1
vote
1answer
674 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
1answer
733 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
1answer
581 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 ...
7
votes
1answer
4k 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
1answer
2k 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
2answers
3k 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
3answers
622 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
3answers
14k 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
2answers
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 ...
27
votes
3answers
134k 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
1answer
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
3answers
1k 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
1answer
1k 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 ...
5
votes
2answers
21k 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 ...
15
votes
1answer
87k 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 ...