Questions tagged [password]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
14 views

dual-password-like feature for MySQL before v 8.0

tldr; Is there a dual-password-like feature for MySQL v.5.x ? Problem I have a MySQL server that needs to temporarily allow two passwords for one account, due to legal constraints that impose DBMS ...
user avatar
  • 13
1 vote
1 answer
33 views

Password storage best practices

We have a system (.NET application + sql server) where in addition to regular user passwords we need to store passwords that are used by the application processes to access various other subsystems or ...
user avatar
  • 11
0 votes
0 answers
16 views

3DES Decryption Returning Encrypted Characters at End of Decrypted Password

I'm having a problem with password decryption that has worked correctly for some 10 years in a VB6 DLL but now on newer, faster servers, it's returning the last few encrypted characters of the stored ...
user avatar
0 votes
0 answers
10 views

password changed date of Mango DDB users

How can I find the password_change_date of users in MangoDB? Can I get a query to get this info.? For example in Oracle, we can gather it from dba_users table by selecting username, ...
user avatar
  • 1
0 votes
0 answers
28 views

Can't log in phpmyadmin, also can't acces the database

My website seems to have been "played" with, I was not able to log in wordpress. I entered my phpMyadmin and I edited the administrator password directly in the wp_users table and I managed ...
user avatar
  • 1
0 votes
1 answer
81 views

Why can't reset password for postgres?

I can login postgresql database without password : sudo -u postgres psql Now i want to reset password 'xxxxxxxx' for postgres: sudo -u postgres psql postgres=# ALTER USER postgres WITH PASSWORD '...
user avatar
  • 126
0 votes
0 answers
24 views

Oracle: ASM password file on RAC DB to create standby, how make it work?

In 19c I have a RAC DB with its pwd file located on +DATA/DBUNAME/orapwfilealias pointing to +DATA/DBUNAME/PASSWORD/orapwdbuname.356.1186610343 (as a result of command 'orapwd file=+DATA/...'). I've ...
user avatar
  • 31
2 votes
1 answer
190 views

CREATE LOGIN "MUST_CHANGE" does not work for Azure

I want to create logins for users for my Azure SQL database. Naturally I don't want to know the users' passwords so I want to set it up so that they HAVE to change their password on first login. ...
user avatar
  • 167
3 votes
1 answer
4k views

How can I change the master password of pgAdmin 4 without resetting it?

pgAdmin 4 has a master password which is required to secure and later unlock the saved server passwords. This is applicable only for desktop mode users. I know my current master password, however, I ...
user avatar
  • 2,117
0 votes
1 answer
63 views

Oracle - Understanding Password Hash Versions

We ran into a problem, and so we're trying to understand all about the password versions. Here is what happened: We upgraded from 11g to 12c. Our sqlnet.ora had this parameter: SQLNET....
user avatar
-1 votes
1 answer
647 views

How to migrate from MySQL 5.7 to 8.0 non-inplace

Hi I have a new Ubuntu 20.04 server, and an old 18.04 server which I am retiring. 18.04 runs MySQL 5.7 and 20.04 runs MySQL 8.0. In the old days, I'd simply do a mysqldump --all-databases and then ...
user avatar
0 votes
2 answers
49 views

Designating no password for account in MySQL config file

This is a theoretical question because having a DB account with no password is a terrible idea. Question: Is there a way to designate an account with no password in the MySQL config file?
user avatar
  • 235
0 votes
3 answers
138 views

Supplying root password to MySQL V8 sort of fails

On Ubuntu 20.04 I have installed MySQL V8.0.25. But I kind of fail to apply a (valid) root password. The apt-get process for installing mysql-server did not ask for a root password. And I cannot enter ...
user avatar
  • 101
-1 votes
1 answer
40 views

Fields for storing user passwords

What coulmn heads would you need, generally speaking, for storing user passwords in a database, and what would be their datatypes be (irrespective of specific hashing/encryption algorithm used)? One ...
user avatar
  • 9
0 votes
1 answer
57 views

Can SSIS packages call other SSIS packages in the connection string?

I am running an SSIS package that transfers data from one (SQL2008) server to another (SQL2000). However after P2V conversion the SQL2008 server cannot execute an SSIS package due to a user ...
user avatar
  • 75
0 votes
1 answer
39 views

Store server password in table for reading with CURSOR

I would like to connect to multiple servers using Linked Server do download table and do queries. I want to store server IP in a table and go down the list using CURSOR to connect to each. I would ...
user avatar
  • 109
1 vote
1 answer
284 views

MariaDB root password change using Ansible

I had tried to change MariaDB root password using following Ansible script. - name: Dump MySQL root Password debug: msg: "MySQL new Password : {{ mysql_pass }}" ...
user avatar
1 vote
0 answers
96 views

What's the problem with my password while installing Apex 20.1?

I am installing Apex 20.1 on my windows 10 with oracle 19c. After running the command : @apxchpwd.sql I get this error even after respecting all the password regulation and trying different ...
user avatar
0 votes
1 answer
297 views

Do I have to worry that root user can login into MariaDB 10.5 without password

I remember when installing MySQL Server 8.0, or in some database setups, there are warnings about no password login. Should I worry about this? I think if someone gets access to root user on my debian ...
user avatar
  • 101
0 votes
1 answer
116 views

SID for SA account

I want to change the SA password for the always on availability group servers. Since i wanted to keep the same password on all the replicas when I tried to transfer the login through Microsoft Stored ...
user avatar
  • 1,007
1 vote
0 answers
56 views

Why is the authentication_string different from the other one if the passwords are the same?

I've set the same passwords for the following accounts: 'root'@'%', 'root'@'127.0.0.1'. When I type select user, host, authentication_string from mysql.user I get different values for the ...
user avatar
1 vote
1 answer
230 views

Why does CURRENT_USER() show the root@::1 when I login to MySQL?

I've set 3 different passwords for the following accounts: 'root'@'localhost', 'root'@'127.0.0.1' and 'root'@'::1'. By typing: mysql -u root -p I can only login with my 'root'@'::1' account password ...
user avatar
0 votes
1 answer
118 views

Why has my root password changed after I updated MySQL from 5.7 to 8.0?

I have set my root account passwords like this: mysql -u root SET PASSWORD FOR 'root'@'localhost' = PASSWORD('pswd1'); SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('pswd2'); SET PASSWORD FOR 'root'@'...
user avatar
0 votes
4 answers
2k views

What privileges do I need to change the password of sys in an Oracle Database?

Our identity management tool wants to change the sys password regularly. It fails with the ORA-01031. What privileges or roles do I need to grant the identity management tool user to be able to change ...
user avatar
  • 868
0 votes
0 answers
49 views

Is there a way to pass the password more securely while scheduling backups in MySQL?

I run the batch file like this: mysqldump.exe --user=uuu --password=pswd --host=localhost --port=3306 --result-file="c:\mydata\backups\db_backup.%date:~0,2%-%date:~3,2%-%date:~6,4%_%time:~0,2%.%...
user avatar
0 votes
1 answer
1k views

Retrieve or reset the password for PostgreSQL on Linux

I have installed Postgres on my Linux system. I forgot the admin password I want to reset the password. How can I do that?
user avatar
2 votes
1 answer
2k views

Can't set root password after fresh installation of mariadb using ansible

Problem: After a fresh installation of mariadb 10.4 the root password could not be set using ansible. When installing mariadb from the debian packages by mariadb (not the official debian packages), ...
user avatar
  • 171
1 vote
1 answer
2k views

What's wrong with my provided admin password for Oracle Apex instance administrator account?

I have installed Oracle Database 19c Enterprise Edition on Oracle Linux 7.8.I am now trying to install Apex 20.1 . Got to the chapter "5.4.2.3 Running apxchpwd.sql" to set the instance ...
user avatar
  • 113
2 votes
1 answer
176 views

Function accepts only certain passwords in postgreSQL

I have created a function in a postgreSQL(v10.10) database to create new users or update existing ones. As parameters you pass the username, password, role memberships, first name and last name. In my ...
user avatar
  • 123
1 vote
1 answer
93 views

Generating a password that matches the Password Validation Component

MySQL 8 has a pretty sophisticated "Password Validation Component" (this replaces the validate_password plugin). It has a lot of options, validate_password.number_count validate_password....
user avatar
  • 55.7k
1 vote
0 answers
37 views

ODBC.ini Password to MS SQL [closed]

I want to change password to a more complex one. I have access as SA to the MS SQL database and it's no problem to change the password. The problem is: I have a odbc.ini for a Windows programm to use. ...
user avatar
0 votes
1 answer
493 views

Set up a postgres database with a specific role without password prompt

Context I have a PostgreSQL server (localhost:5432) which holds a database called my_database. I have created long time ago, a simple role which owns this database; my_user, different from the ...
user avatar
  • 216
0 votes
1 answer
65 views

Defining password complexity and its action on "grace" state USERS

I have Oracle USERS linked to external applications that came to "grace" status. I tried to change the assword time expiration to unlimited but it doesn't apply to those account (considering I guess ...
user avatar
1 vote
1 answer
62 views

Logging security events in MSSQL

I need to log events of admin changing someone's password, and user changing his password. How do I do that? I've found a nice solution based on Service Broker, however the resulting table only ...
user avatar
1 vote
0 answers
105 views

MySQL Password Validation - No previous passwords

I wonder if there is any possibility to use the password validation for MySQL 5.6 (https://dev.mysql.com/doc/refman/5.6/en/validate-password.html) to prevent for example the last 4 passwords. The ...
user avatar
  • 11
0 votes
2 answers
1k views

MySQL 8.0.17 on Windows - I forgot my root password, dont need to keep any previous DBs

I have previously used MySQL for a class about a year ago and not since. I've forgotten the password and I need to use it again. I don't need to be able to access any previous databases, so I tried ...
user avatar
6 votes
1 answer
618 views

SQL Server - How does contained database user password expiration work?

I've recently started working with contained databases and I do not understand if/how contained database users have passwords that expire. MSDN documentation says they do - With a SQL Server login, ...
user avatar
9 votes
4 answers
17k views

In PostgreSQL URL I can't use a password containing special characters

I have a postgresql database in Azure The passwd string has special characters like these: )mvd99/iyH_=ag=Por/W}%%aKY^ygt+,sC7%%P?APOU psql --dbname=postgresql://db_user@mydemoserver:)mvd99/iyH_=ag=...
user avatar
  • 91
3 votes
2 answers
216 views

Find accounts with passwords that are not complex

I can see all the SQL Login passwords that enforce the password policy with this command SELECT * FROM sys.sql_logins WHERE is_policy_checked = 1 However, it seems that when the enforce password ...
user avatar
  • 1,450
2 votes
2 answers
5k views

can't update user password on Mongodb 4.0.5 (Use of SCRAM-SHA-256 requires undigested passwords)

I'm trying to update a password from a user, using changeUserPassword(), and I just receive the following message: Error: Updating user failed: Use of SCRAM-SHA-256 requires undigested passwords &...
user avatar
2 votes
1 answer
111 views

Log report 'bad password', but still grants access

Original symptom: User sa locked out, too many bad attempts. Problem was sudden (no issues before), and pervasive (couple of fails in one day). As this was a new roll out of SQL backend to Sage300, ...
user avatar
2 votes
2 answers
584 views

Change user password on slave

Our users can only access the slave database. How can I let them change their passwords on their own or when their passwords expire?
user avatar
  • 23
1 vote
4 answers
21k views

Default phpMyAdmin Login Credentials

I downloaded and installed phpMyAdmin 4.8.5 on my windows. Upon opening it in the browser, it immediately asks for a Username and Password. I tried to submit root for username while leaving the ...
user avatar
  • 121
0 votes
1 answer
1k views

How to know or recover my pg_dump password? [closed]

I would like to backup my Postgre db using pg_dump. However, the first question asked by the prompt is the password. But I have no idea what it is. Indeed, it is different from my admin account ...
user avatar
  • 127
0 votes
2 answers
23k views

Retrieve user password in Oracle [closed]

How to obtain the password of a specified user in Oracle? What query to use to obtain that?
user avatar
1 vote
1 answer
774 views

How to verify if given user@host with 'password' exists in MySQL 8.0+?

I write sanity check script for an application. One of the tests is supposed to verify that a given user@host with 'password' exists in MySQL. I'm using simple native hash passwords. In MySQL5.7- ...
user avatar
  • 193
1 vote
0 answers
55 views

Case sensitive logon on some users

Looking for a way to let selected users have case-sensitive logon check on Oracle 12.1. Setting SEC_CASE_SENSITIVE_LOGON = TRUE enables all users to have case sensitive logon, but trying to limit that ...
user avatar
1 vote
1 answer
2k views

Problems with connecting to a remote Oracle 12c database

tl;dr RMAN failing to connect to standby database with correct credentials. RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied Password file is correct, ...
user avatar
  • 23
1 vote
1 answer
1k views

Can the new “SCRAM-SHA-256” password authentication mechanism in Postgres 10 and later work with any JDBC drivers?

Postgres 10 added support for a new password authentication mechanism, Salted Challenge Response Authentication Mechanism (SCRAM-SHA-256, see RFC 7677). Discussed by Michael Paquier. ➥ Can this ...
user avatar
1 vote
1 answer
528 views

Is it overkill to encrypt an already hashed BCrypt password?

I'm using BCrypt to hash my passwords on the server side. Before I store it in my MySQL database, would it be overkill to encrypt my hashed-BCrypt password or would storing the hash directly in the ...
user avatar
  • 39