Questions tagged [password]

The tag has no usage guidance.

26 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
1 answer
4k views

MySQL passwords SHA512 using AES_ENCRYPT instead of ENCRYPT?

A tutorial is asking me to encrypt passwords using SHA512 in the following manner: INSERT INTO `vir_users` (`id`, `domain_id`, `password` , `email`) VALUES ('1', '1', ENCRYPT('pw1', CONCAT('$6$', ...
Henry van Megen's user avatar
2 votes
0 answers
78 views

SQL Server not checking for expired passwords

We are using SQL Server 2005 on Windows Server 2008 with Windows Authentication where access is granted to members of a specific domain group. Clients are VB6/ADO applications that connect via an ...
Colin Baker's user avatar
2 votes
0 answers
2k views

MySQL workbench won't import my sql file

I have an SQL file im trying to import via mysqlworkbench but I keep getting the error: Access denied for user 'wordpressuser79'@'localhost' (using password: NO) Operation failed with exitcode 1 ...
darrrrUC's user avatar
  • 121
2 votes
0 answers
1k views

When does SQL Server follow the Minimum Password Age policy?

According to this SQL Server 2008 whitepaper, SQL Server should only pay attention to the Minimum Password Age policy when the Check_Expiration (Enforce Password Expiration) option is turned on. Page ...
CowherPower's user avatar
2 votes
0 answers
3k views

Why OEM RMAN backup jobs fail after changing the preferred credentials?

In an Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production, Running on Oracle Linux 6.5, we configured full RMAN backup schedule using OEM (Oracle Enterprise Manager 11g ...
amyassin's user avatar
  • 131
1 vote
1 answer
168 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 vote
0 answers
50 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
1 vote
0 answers
225 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
284 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
1 vote
0 answers
169 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
1 vote
0 answers
534 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
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
1 vote
0 answers
58 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 ...
Jostein Topland's user avatar
1 vote
0 answers
173 views

Resetting MySQL Workbench 6.3 CE password

I'm a rookie using MySql Workbench 6.3 CE on Windows 10. Before I could even try to open my first data table to begin learning SQL, I've managed to forget my password. Can someone help me re-set it ...
Beth's user avatar
  • 11
1 vote
0 answers
1k views

SQL Server opendatasource reading a password protected Excel file

I would like to read a password protected Excel workbook and I'm not sure what the syntax is to enter this parameter. I found only passwords for the connection, which is not needed due to login. I ...
Eyal Philippe Ri's user avatar
1 vote
0 answers
3k views

Postgres user without password

I'm creating unit tests on a python application that uses digital certs on the server. Since I am not testing the connection between the server and the database, I need to setup the temporary test ...
Robert Daniels's user avatar
0 votes
0 answers
48 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
811 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
0 votes
0 answers
40 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
0 votes
1 answer
654 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
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
  • 362
0 votes
1 answer
384 views

MySql global variable disconnect_on_expired_password

This is very annoying.... disconnect_on_expired_password is set to ON. MySql version is: Server: Localhost via UNIX socket Server type: MySQL Server version: 5.7.5-m15 - MySQL Community Server (GPL) ...
Jadeye's user avatar
  • 101
0 votes
0 answers
884 views

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Im trying to to dump an old database system to migrate the data. # mysql --version mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 The weird part is this: # mysql -u ...
jdoe123456's user avatar
0 votes
2 answers
3k views

Cannot change MySQL root password

I have run the following commands found here. shell> mysql mysql> FLUSH PRIVILEGES; mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass' But when I go to login as root, I can type ...
crayden's user avatar
  • 101
-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
-1 votes
1 answer
445 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