Where mysql stores the password of users [closed]

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?

Answer 1

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

Answer 2

in the mysql db, user table

SELECT
    User,
    Password
FROM mysql.user;