MySQL Forums
Forum List  »  Newbie

Can I audit Mysql user last login attempts ?
Posted by: yvonne kire
Date: October 29, 2018 12:28PM

Is there a way to find out when mysql user last logged in to mysql?
is there some internal table that keep track of this ?

I don't see any timestamp column in mysql.user table (5.7)
Is anything turned on by default?
or there is no way to say when user XXXX was last connected to a DB?
I see there is a information_schema.USER_STATISTICS but it's empty

mysql> select * from USER_STATISTICS ;
Empty set (0.04 sec)

Options: ReplyQuote

Written By
Can I audit Mysql user last login attempts ?
October 29, 2018 12:28PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.