The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
11 views

MySQL/MariaDB CLI limits max password?

I've got strange problem - my MariaDB instance CLI (Linux) does enforce limit on how long password can be. For example, setting password like this UPDATE mysql.user SET ...
0
votes
1answer
25 views

Postgresql: When using SSH tunnel, I receive the fe_sendauth: no password supplied error

I am SSH Tunneling to my postgreql server. I have previously successfully configured 9 + win XP dev PCs to connect to this postgresql server, those PCs still connect successfully. I am now setting up ...
5
votes
0answers
133 views

Why would you use a managed service account rather than a virtual account in SQL Server 2012?

In SQL Server 2012, service accounts are created as virtual accounts (VAs), as described here, as opposed to managed service accounts (MSAs). The important differences I can see for these, based on ...
0
votes
2answers
31 views

How to use passwords to protect database data

Hello another newbie question for all the database/web experts out there.... I have read a lot about protecting passwords stored in a database using hashes, salts, encryption algorithms etc. To avoid ...
0
votes
1answer
49 views

Oracle case insensitive passwords seemingly ignoring SEC_CASE_SENSITIVE_LOGON

I'm trying to change the SYS password of an Oracle 11g database to be case-insensitive for legacy application reasons. My research suggests all I need to do is set the SEC_CASE_SENSITIVE_LOGON flag, ...
0
votes
1answer
49 views

Forgot mysql owner/root username and password

Recently, I changed my mysql root user to someother username (say kevin). But, now both the accounts don't login with the old password. It says access denied. I'm also not sure if the username is ...
0
votes
0answers
88 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 ...
4
votes
2answers
85 views

Why shouldn't a pre-hashed password be used with CREATE LOGIN all the time?

(For the purpose of this question, assume that I only need to support SQL Server 2008 and higher. Or to future-proof this question, let's say recent, current, and near-future versions.) The ...
3
votes
1answer
55 views

Error with restoring from a split .bak file with password

I am trying to restore a backup from a split .bak file[.bak_1/.bak_2/.bak_3]. The backup is password protected. So far this is what I have and I cannot seem to format in a way that does not throw me ...
1
vote
0answers
44 views

'sa' Password Managment [closed]

I have been asked about my ideas regarding how often to change sa passwords and how best to manage this process. Users who are sa by right of user role are managed by the general password policy of ...
1
vote
1answer
84 views

“Set Password” with a limited user

I'm using MySQL 5.6 and I want to have a limited service-user which is able to create/modify the users of my databases. Now my problem is that I can quite figure out what privileges my service-user ...
0
votes
2answers
118 views

how to access my password in SSIS 2005 by VB.NET

A VB.NET component delivered following message: Login failed for user MyDBUser It is about an OleDbConnection. btw The user works fine togehter with SQL Server Management Studio. Retaining a ...
1
vote
3answers
330 views

MYSQL - Unable to change 'old_passwords' variable

I have full access to a 'MYSQL 5.0.27-community-nt-log' database one of our new updates for a core app requires PHP 5.4, after installing and configuring I'm stuck at the error regarding old vs. new ...
1
vote
1answer
43 views

Change mysql password interactively

Is it possible to change the user password in mysql in an interactive mode like it one can do in PostgreSQL for example using \password command? My goal is not to provide the new password together ...
2
votes
1answer
112 views

Recover encrypted Oracle database

A client fired their DBA. He used OWM to add a wallet to their Oracle database and secure a few necessary columns of tables that they need. I can see the walled using: orapki wallet display -wallet ...
0
votes
2answers
177 views

Password encryption type

I would like to confirm if MySQL uses SHA1 for 'PASSSWORD' hashing and why test below doesn't work: mysql> GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows ...