Where mysql stores the password of users

Question

When we setup a MySQL database system, system automatically create a MySQL databse in which there are multiple tables like db,event,func,host,servers,slow_log,user_info etc. In user_info table I can get the list of users and their details by executing query like select * from user_info; except password.

But in which table MySQL store the password of every users?

score 4 · Answer 1 · answered Feb 18 '14 at 06:47

4

in the mysql db, user table

SELECT
    User,
    Password
FROM mysql.user;

answered Feb 18 '14 at 06:47

silly

7,789
2
24
37

I have `user_info` table instead `user` in which it doesn't contain password column. – ursitesion Feb 18 '14 at 07:18

score 4 · Accepted Answer · answered Feb 18 '14 at 06:48

4

MySQL passwords for users are stored within MySQL itself; they are stored in the mysql.user table. The passwords are hashed by default using the PASSWORD() function.

Source

answered Feb 18 '14 at 06:48

Vivek Sadh

4,230
3
32
49

How to unhash the password and see it? I forgot the password but i cannot change it, it has to be the default one because there are many users using it for Excel sheets. – Raul Chiarella Jan 29 '22 at 12:28

Where mysql stores the password of users

2 Answers2