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?
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.