Questions tagged [password]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
52 views

Reset root password in MySQL

I am logging in with root user in MySQL, and the server has been hardened, so this parameter is set default-authentication-plugin=caching_sha2_password, and this is currently the only user I have. ...
datascinalyst's user avatar
0 votes
2 answers
146 views

SYS password has expired and cannot be changed due to ORA-00257: Archiver error

In the past : When I had once the error ORA-00257: Archiver error, I had resolved it using the RMAN command: rman target sys/1234 delete archivelog all; This time , when I try to connect to rman ...
eathan's user avatar
  • 23
1 vote
1 answer
141 views

viewing the password of a connected SQL Server user

Using SSMS, the system had me change the password on the user I was using. Changed it and thought knew what I was changing it to. Have done a Save Password. So I am able to get in via SSMS, but ...
Doug's user avatar
  • 11
-1 votes
1 answer
406 views

Why does postgres allow me to access localhost without any password regardless of role?

I was under the impression that Postgres used some local socket magic to allow a local user to access postgres without password, whereas passing the host (-h) option would force it to use TCP and thus ...
oligofren's user avatar
  • 155
1 vote
0 answers
48 views

Issue with hash storage resulting from password_verify() output

Consider the following code: $random_token = random_bytes(32); $token_hash = password_hash( $random_token, PASSWORD_DEFAULT ); $token_base64 = sodium_bin2base64( $random_token, ...
DevelJoe's user avatar
  • 163
0 votes
1 answer
639 views

MySQL Prompt Users to Reset Passwords during first login

I have this set of user accounts that I desire to create with default passwords then force the users to change passwords at first login. Plus, I wanted to force all user accounts to be resetting ...
franklwambo19's user avatar
1 vote
1 answer
3k views

How can make PG_DUMP work without asking password?

I have set pgpassword in .bashrc: vim .bashrc export PGPASSWORD=pass_for_postgresql It is no need to type password for command psql -U postgres. When i dump a table from db1 into db2 with : pg_dump ...
showkey's user avatar
  • 324
5 votes
2 answers
5k views

Password character issues for } and ' in SQL connection string

I am using ODBC Driver 17 to connect to MSSQL server. To avoid SQL injection possibilities, have enclosed password in {}. Now, am facing issue if I give a password like }qwerty1234. i.e. a password ...
Amal Jesudas's user avatar
1 vote
1 answer
1k views

Can't get MariaDB docker to work without password

I want to add MariaDB to my docker compose file, like this: version: '3' services: mariadb: image: 'mariadb:10.3' ports: - "3306:3306" volumes: ...
7ochem's user avatar
  • 123
0 votes
0 answers
33 views

Application Role - Reset Password using hash or Encryption form

I need to automate reset password of database application role. Password must be encrypted or hash form due to security reason. I tried to convert password in hash form using 'Hashbytes' as mentioned ...
SQLHoncho's user avatar
1 vote
0 answers
199 views

Enter psql without password requirement for user postgres

I have set PGPASSWORD in my .bashrc: export PGPASSWORD=mypass Now i can enter into psql with : psql -u postgres Set nopasswd in /etc/sudoers user ALL=NOPASSWD:/bin/su - postgres Then i toggle to ...
newview's user avatar
  • 111
1 vote
0 answers
264 views

Changing root and user passwords in MariaDB 10.5?

We have a few MariaDB servers (MariaDB 10.5, running on Debian 11/bullseye) where we need to change the passwords for the DB root user and for other user accounts in the DB system (by which I mean ...
dave559's user avatar
  • 121
11 votes
1 answer
49k views

How to get a user's password in PostgreSQL?

I am logged into my database as superuser postgres. postgres=# SELECT * FROM pg_user; +----------+----------+-------------+----------+---------+--------------+----------+----------+-----------+ | ...
showkey's user avatar
  • 324
0 votes
1 answer
624 views

MySQL Plugin "mysql_old_password" not loaded

In an attempt to fix another issue I had, I ran the commands below (as per https://dev.mysql.com/doc/refman/5.6/en/old-client.html) mysql> UPDATE mysql.user SET plugin = 'mysql_old_password' mysql&...
The Royal Guardian's user avatar
2 votes
1 answer
14k views

ERROR 1045 (28000) & access denied for user 'root'@'localhost'

UBUNTU 22.04.1, mysql ver 8.0.30 (1) I get sudo apt install mysql-server then sudo mysql_secure_installation Get in loop this error for each complicated passwords I tried: (contained: '<>&(*...
mgae2m's user avatar
  • 161
2 votes
1 answer
175 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 ...
cp103's user avatar
  • 33
2 votes
1 answer
810 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 ...
ArtW's user avatar
  • 21
0 votes
1 answer
877 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 '...
showkey's user avatar
  • 324
2 votes
1 answer
1k 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. ...
Tessaract's user avatar
  • 167
7 votes
1 answer
18k 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 ...
Glorfindel's user avatar
  • 2,201
0 votes
1 answer
302 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....
Landon Statis's user avatar
-1 votes
1 answer
3k 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 ...
Alistair Ross's user avatar
0 votes
2 answers
586 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?
Sandeep's user avatar
  • 255
0 votes
3 answers
688 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 ...
Ulrich's user avatar
  • 101
-1 votes
1 answer
401 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 ...
vollot's user avatar
  • 9
0 votes
1 answer
110 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 ...
mcv110's user avatar
  • 75
0 votes
1 answer
47 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 ...
Lightsout's user avatar
  • 109
1 vote
1 answer
1k 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 }}" ...
Sachith Muhandiram's user avatar
1 vote
0 answers
164 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 ...
Chadi Hani's user avatar
0 votes
1 answer
586 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 ...
Ehsan88's user avatar
  • 101
0 votes
1 answer
420 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 ...
SQL_NoExpert's user avatar
  • 1,049
1 vote
0 answers
509 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 ...
JConstantine's user avatar
1 vote
1 answer
575 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 ...
JConstantine's user avatar
1 vote
1 answer
594 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'@'...
JConstantine's user avatar
0 votes
4 answers
4k 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 ...
r0tt's user avatar
  • 998
2 votes
1 answer
12k 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
3k 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), ...
toydarian's user avatar
  • 201
1 vote
1 answer
4k 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 ...
alvarez's user avatar
  • 115
2 votes
1 answer
449 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 ...
pascatl's user avatar
  • 123
1 vote
1 answer
140 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....
Evan Carroll's user avatar
  • 62.7k
1 vote
0 answers
102 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. ...
nodody2020's user avatar
0 votes
1 answer
2k 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 ...
s.k's user avatar
  • 352
0 votes
1 answer
545 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 ...
Antoine's user avatar
1 vote
1 answer
79 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 ...
mekkanizer's user avatar
1 vote
0 answers
127 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 ...
niecke's user avatar
  • 11
0 votes
2 answers
2k 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 ...
Jacob Myer's user avatar
6 votes
1 answer
986 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, ...
Will Southwood's user avatar
19 votes
5 answers
44k 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=...
Sanx's user avatar
  • 191
3 votes
2 answers
380 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 ...
SE1986's user avatar
  • 1,960
3 votes
2 answers
7k 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 &...
ivanleoncz's user avatar