Skip to main content

Questions tagged [password]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 views

How to replace users passwords with yaml variables?

I am writing a MySQL script defining users and roles, but I don't want to upload the password to the repository. So I was guessing if I can replace those passwords with yaml variables. USE test; DROP ...
Eduardo Jiménez's user avatar
0 votes
0 answers
52 views

Does a system protected password automatically get included in SSMS when it is downloaded?

I work at a company where most things are password protected by a system admin password (which I dont have). Today I downloaded SQL Server and set up a basic local server. I was able to get in but ...
Matt Damberg's user avatar
0 votes
2 answers
52 views

Using pgdump_all and cron

I have a daily cron job to dump my database. Part of the crontab includes the following: 01 01 * * * root /etc/cron.d/backupDaily.sh and part of the backup script contains the following: ...
Manngo's user avatar
  • 2,849
0 votes
0 answers
52 views

How do I store a password in such a way that I can obtain the plain-text password again?

Consider the following scenario: My app is utilizing a third-party API which requires a username and password for authentication. Unlike most APIs, which have one username and password set for the ...
JCollier's user avatar
  • 101
0 votes
1 answer
64 views

MySQL CLI asks for password but doesn't use it

I'm trying to connect to a remote MySQL database for replication. The database is on a machine that's part of a secured network, so after opening the security enough to allow my replication ...
Spencer Ke's user avatar
0 votes
1 answer
109 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
261 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
230 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
666 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
53 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
1k 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
5k 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
  • 334
5 votes
2 answers
6k 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
2k 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
43 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
266 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
309 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
12 votes
2 answers
65k 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
  • 334
1 vote
1 answer
754 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
190 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
877 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
972 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
  • 334
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
20k 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
379 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
711 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
  • 265
0 votes
3 answers
867 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
524 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
118 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
49 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
188 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
619 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
476 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,061
1 vote
0 answers
558 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
643 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
689 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
5k 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
  • 1,028
2 votes
1 answer
15k 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
  • 213
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
472 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
2 votes
1 answer
160 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
  • 63.8k
1 vote
0 answers
109 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
  • 372
0 votes
1 answer
678 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
81 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
129 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