You are here

Home

user password change date

Wed, 2013-10-30 11:37 — kalasha
Dear friends, Is there is any command to check when user and password created in MySQL user table. I want command for user logins last password change date and password created date. in MSSQL we are able to take where as in MySQL unable to take. Kindly help me
Taxonomy upgrade extras: 
general query log

I don't think that there's such way in MySQL like MSSQL to track users modifications, but you can check the general log file (if it's enabled) and search for all DCL statements related to the user in question.
In the general log file, MySQL records all commands received by the client along with the issuance timestamp.
I hope that helps..

abdel-mawlacomment Wed, 2013-10-30 17:28