Skip to main content

Questions tagged [password-recovery]

Filter by
Sorted by
Tagged with
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 --...
user2112's user avatar
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 ...
illright's user avatar
  • 111
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 ...
Dean's user avatar
  • 21
-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: ...
Hassan's user avatar
  • 1
-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)
Kwabena's user avatar
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 ...
Frank Martin's user avatar
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 ...
user151976's user avatar
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 ...
Rauf Asadov's user avatar
  • 1,303
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 ...
K Pekosh's user avatar
  • 111
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/...
Chathura Buddhika's user avatar
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 ...
Evan Carroll's user avatar
  • 64.7k
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
  • 64.7k
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 ...
user avatar
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 ...
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
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 ...
John T.'s user avatar
  • 21
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 ...
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
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 ...
AKIWEB's user avatar
  • 615
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
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 ...
Jonas's user avatar
  • 33.6k