Discover user password through Select or View? [closed]

Question

Discover user password through Select or View? [closed]

Navigation

#1 by (3 votes)

-1

I'm running a BD that was done by a developer who created a table of operators, it happens that he is no longer in the world of the living.

How to find a user's password through a table or a View using SELECT * FROM ?

sql view

asked by anonymous 12.09.2017 / 17:51

1 answer

Error inserting data into PHP database PDO [duplicate] Read fasta files in python and skip the first line

score 3 · Answer 1

If the passwords are encrypted then it will be very difficult to get them to read, a way to resolve in this case would be to access the project or code, where password encryption is generated.

On the other hand if you do not have any type of encryption the passwords, a select will suffice to return everything you need, you can use the examples below to query your DB and the desired fields.

To see all the fields and records of a table in the DB:

SELECT * FROM nome_tabela;

To query all records for a given field in a table:

SELECT nome_campo FROM nome_tabela;

If you want to pass a certain user you can do this:

SELECT * FROM nome_tabela WHERE nome='ze';

Or

SELECT pass FROM nome_tabela WHERE nome='ana';

Something where you can help, please see more information here MYSQL or here W3Schools , about using SELECT in DB queries.