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 11g database to 12c. I have done this before on 11g to 11g, but not able to replicate / find how to do this on 11g to 12c. Thanks!

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 --skip-grant-tables --skip-networking & followed by mysql -u root or sudo mysql -u root but I'm met with the response ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (111) This is true as it doesn't look to be running on port 3306. Using sudo mysqld_safe --skip-grant-tables --skip-networking PORT=3306 & also doesn't work. MySQL rungs quite happily on TCP 3306 when started using sudo systemctl start mysql.service chris@ubuntu-util:~$ sudo mysqld_safe --skip-grant-tables --skip-networking & 7261 chris@ubuntu-util:~$ 2024-06-05T06:49:43.386242Z mysqld_safe Logging to '/var/log/mysql/error.log'. 2024-06-05T06:49:43.390991Z mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists. mysql -u root ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (111) + Exit 1 sudo mysqld_safe --skip-grant-tables --skip-networking Does anyone have any suggestions as to how to sort this?

Cannot log in to the MySQL server they say mysqli::real_connect(): (HY000/1045): Access denied for user 'Stephen Ankoh'@'localhost' (using password: YES)

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 out of the question. By nature of Dockerized PostgreSQL, if you specify your own username, the role postgres will not be created. That means that postgres, admin, root are all invalid roles on my DB instance. Now I'm stuck with a data directory in a volume that I can access and a psql that I cannot access because I don't know any valid username on that database. Is there a list of usernames in this data directory that I can somehow access to get inside and change the password?

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 VB6 app for strings and I've found the uid but the password is eluding me. I'm hoping there's a way to record this information at the SQL Server, rather than reverse-engineering the old VB6 app. The VB6 app is using OLE DB to connect to SQL. I wondered if there was a way to get OLE DB to dump the connection string. This would also give me the info I need. I don't have any source available. I think the password is created in RAM based off some other variables available. It's not in the OLE DB config manager. The old VB6 app doesn't use the same password for SQL at every install. It's not a hard-coded password. That's why I was hoping to get it on the server-side.

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: invalid username/password; logon denied

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 password? Or is it happening due to presence of $ and @ in password? UPDATE mysql.user SET Password=PASSWORD('$kjD q6 MM paSSword@') WHERE User='root';

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/mysql_secure_installation I have never set a root password and I'm logged in to Linux as root user. Then I have found following documentation for resetting root password and followed that one too. https://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html But even after starting the server with following command it is asking for a password /etc/init.d/mysqld start --skip-grant-tables & I have tried starting the server with init-file option, but no success. Does anyone know how to reset the password correctly or default MySQL 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 installed it. I have googled and found a [post](http://www.postgresql.org/message-id/6BCB9D8A16AC4241919521715F4D8BCE476A42@algol.sollentuna.se) related to resetting your password. I followed the steps, but the end result is a bit different then mentioned in the post. I used— net user postgres postgres to reset the password for my database but instead of a success message I am getting: > "System error 5 has occurred. Access is denied." system error. How do I avoid this error and reset the password?

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 administrator, so I can run command line as admin. Is it possible?

The instructions on [technet](https://social.technet.microsoft.com/wiki/contents/articles/37856.sql-server-on-linux-how-to-change-sa-password.aspx) 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 way to reset the password on Linux?

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 file, I have: UPDATE mysql.user SET Password=PASSWORD('newpassword') WHERE User='root'; So I do a clean shutdown of the database, and then: mysqld_safe --init-file=/root/mysql.password I get 'starting mysqld' ... and then it exits with code 1. I don't get it. What's wrong with that file? Using .. mysqld_safe --skip-grant-tables & .. isn't an option, unfortunately, as it's a public-facing production box. Thanks.

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 therefore I need to configure a user (GRANT SELECT ON heartbeart to 'nagios-monitor'@'123.123.123.123') for that operation with appropriate permissions granted to the nagios server host, or nrpe script host. I'd like to have an automated installer script, to configure the table. Hence I would like to be able to carry out these operations automated, with little risk to the underlying application uptime. 1. It is not always clear what the mysql root user password is. (targets are arbitrarily used developer and test boxes, and they change the passwords) 2. I want to be able to add monitoring without causing any downtime 3. Other strategies to manage users/passwords are fine, but again, I still need to apply those grants without restarting the database. Notes ------ 1. If I install the mysql from scratch, then I add a "dba" type user similar to 'debian-sys-maint' in addition to the root user, with a complex password, which sidesteps the above problem. - this is not the use-case that i am considering here. Possible Solutions === 1. suggestion: Spin up a second mysqld process on port 3307 (with the --init-file option to create my nagios-monitor user), pointed at the same /var/lib/mysql, but masked to only open the "mysql" database consequences?: **probably corrupt everything** - could pause sudo kill -STOP $(cat /var/run/mysqld/mysqld.pid) and then start - sudo kill -CONT $(cat /var/run/mysqld/mysqld.pid) How to force the main mysql to re-read the tables from disk? 2. some sort of scheduled task that is run by mysqld? could append my commands to that, as its not particularly urgent to run the grants. Multiple mysqld === http://dev.mysql.com/doc/refman/5.5/en/mysqld-multi.html > Beware of the dangers of using multiple mysqld servers with the same > data directory. Use separate data directories, unless you know what > you are doing. Starting multiple servers with the same data directory > does not give you extra performance in a threaded system. http://dev.mysql.com/doc/refman/5.5/en/multiple-data-directories.html 5.3.1. Setting Up Multiple Data Directories ---- > Normally, you should never have two servers that update data in the same > databases. > Even when the preceding precautions are observed, **this kind of setup works > only with MyISAM and MERGE tables,** and not with any of the other storage > engines. mysql> SHOW TABLE STATUS where Name = 'user'\G *************************** 1. row *************************** Name: user **Engine: MyISAM** Version: 10 Row_format: Dynamic Rows: 27 Avg_row_length: 91 Data_length: 2476 Max_data_length: 281474976710655 Index_length: 2048 Data_free: 0 Auto_increment: NULL Create_time: 2012-04-12 11:46:21 Update_time: 2013-01-22 00:16:00 Check_time: 2013-01-19 20:52:09 Collation: utf8_bin Checksum: NULL Create_options: Comment: Users and global privileges 1 row in set (0.00 sec) So I spun up a 2nd mysqld on port 3307, with a masked datadir like so; # mkdir /var/lib/mysql2/ # ln -s /var/lib/mysql/mysql /var/lib/mysql2/mysql # /usr/sbin/mysqld --basedir=/usr \ --datadir=/var/lib/mysql2 \ --plugin-dir=/usr/lib64/mysql/plugin \ --user=mysql \ --log-error=/var/lib/mysql2/server-64654.err \ --pid-file=/var/lib/mysql2/server-64654.pid \ --socket=/var/lib/mysql2/mysql.sock \ --port=3307 \ --init-file=/var/cache/chef/grants.sql \ --datadir=/var/lib/mysql2/ with a grants.sql; GRANT ALL ON *.* TO 'nagios-user'@'127.0.0.1' IDENTIFIED BY 'xxx' WITH GRANT OPTION; FLUSH PRIVILEGES; mysql --port=3307 -h 127.0.0.1 -e 'select User from mysql.user' +-------------+ | User | +-------------+ | root | | nagios_user | But the original mysql,doesn;t pick it up until it has been restarted! gah! mysql --port=3306 -h 127.0.0.1 -e 'select User from mysql.user' +-------------+ | User | +-------------+ | root |

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 reset the password for postgres in PostgreSQL on Windows? ---- I followed Milen's suggestion, but got this message when trying to reload the configuration file: C:\Program Files\PostgreSQL\9.1\data>pg_ctl reload -D . pg_ctl: could not send reload signal (PID: 3396): Operation not permitted In Windows there is a menu option "Reload Configuration" that worked better, as shown below:

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 password got me into the database, but I was confused, as I have never been prompted for a password for the default user before. I looked around online on how to circumvent this, and I tried the solution suggested by lalligood on https://dba.stackexchange.com/questions/83164/remove-password-requirement-for-user-postgres?newreg=aa34aebf18274762924df4fb035dedff which was to run alter user postgres password null; and now I cannot access psql. Trying postgres, null or omitting a password does not get me in, and I do not know what to do.

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 there first

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 $ mariadb ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") When I check the logs, I don't see anything.

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 my password, which means if I don't get my password back somehow, or reset, I am basically done with using it for my life. I am using Mac OS 10.10.2 Here is what i have tried: Tried to stop it first, using a script from the oracle site: kill cat /mysql-data-directory/host_name.pid ...getting no such directory error. I terminated MySQL manually from system preferences, and did the following: Everyone is saying to use: mysqld_safe --skip-grant-tables ...but it is not working here. No mysqld_safe command even exists when I punched it into cmd. Then I digged into the directory files, and used: sudo ./usr/local/mysql/bin/mysqld_safe --skip-grant-tables & After i did, it still asked for my password! Then I tried to remove sudo: ./usr/local/mysql/bin mysqld_safe --skip-grant-tables it becomes: fan$ ./mysqld_safe --skip-grant-tables ./mysqld_safe: line 522: /usr/local/mysql/data/mysqld_safe.pid: Permission denied awk: i/o error occurred while closing /dev/stdout input record number 8, file source line number 1 160204 00:21:13 mysqld_safe Logging to '/usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.err'. touch: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.err: Permission denied chmod: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.err: Permission denied 160204 00:21:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data ./mysqld_safe: line 130: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.err: Permission denied rm: /tmp/mysql.sock: Permission denied rm: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.pid: Permission denied rm: /usr/local/mysql/data/guiyang-Fans-MacBook-Pro.local.pid.shutdown: Permission denied Please help to save my life with this mess! I really really don't understand why Oracle wants to give me a so sophisticated password in the beginning instead of asking me to set one! I jotted down the password it gave me, which was a combination (&*,AaFz0). I have updated my termination procedures, and it is not working at all. I have used http://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html to try to solve the problem. I am getting the same thing,the big chunk of nonsense above. Here is what I got: /usr/local/mysql/data/mysqld_safe.pid: Permission denied awk: i/o error occurred while closing /dev/stdout input record number 1, file source line number 1 160204 01:11:50 mysqld_safe Logging to '/usr/local/mysql/data/Fans-MacBook-Pro.local.err'. touch: /usr/local/mysql/data/Fans-MacBook-Pro.local.err: Permission denied

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 version 5.7.9 (MySQL Community Server (GPL)). I installed it as a Windows service, but there were no mysql database, only information_schema. So I executed this: mysql_upgrade.exe --upgrade-system-tables And mysql databases were created. But along with it something happened with root user, because I couldn't access mysql anymore. So I decided to reset this suddenly appeared password (because I didn't have it before that). I founded the following solution in the official manual, I started the server like this: mysqld.exe --skip-grant-tables --console Then I opened mysql without password: mysql.exe –u root And then tried to reset the root password: SET PASSWORD FOR 'root'@'localhost' = PASSWORD(‘passhere'); But I got this error: > ERROR 1131 (42000): You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords". What is this? How am I anonymous? All commands were executed in cmd.exe under the Administrator. What should I do to reset the root password in this situation? **Update 1:** I tried to check the current user: SELECT USER(), CURRENT_USER(); That gives: +--------+----------------+ | USER() | CURRENT_USER() | +--------+----------------+ | root@ | @ | +--------+----------------+ That's weird, because I started it like mysql.exe -u root. Then I checked users table: SELECT user FROM mysql.user; That gives: +-----------+ | user | +-----------+ | mysql.sys | +-----------+ That's even more weird. Also there is no password field: SELECT user, password FROM mysql.user; > ERROR 1054 (42S22): Unknown column 'password' in 'field list' So I cannot change its password. And I cannot create a new user: CREATE USER 'root'@'localhost' IDENTIFIED BY 'passhere'; > ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement Now I'm lost. **Update 2:** I guess, I did everything wrong from the beginning. Apparently, I missed a mysqld.exe --initialize command somehow. So, this is how I installed MySQL from .zip-archive, thanks to *@RolandoMySQLDBA*: 1. Unpack archive, prepare my.ini. 2. Execute mysqld.exe --initialize, get temporary password from the .err file. 3. Install MySQL as a service and run it mysqld --install MySQL --defaults-file="d:/path/to/mysql/my.ini" 4. Connect to it mysql -u root -p with temporary password. 5. Change the temporary password: ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEWPASSWORD';

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, the password it was encrypted with is lost too. We also have the certificate backed up, but those passwords are lost as well. The original backup files (master key, cert) are still in existence and those encryption passwords are available for previous servers these DBs lived on. Question: 1. We want to have the actual passwords on file for the certs/keys used in our environment. What is the best solution? - This is a production environment