Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Access log !!

systemalisystemali AdvisorCurrent User Role Beginner
Hello again,

I need to get the list of IP address from where the percona mysql has been accessed (Mysql access log) and also if possible any dump command that has been issued.

On viewing the servers conf file ( /etc/my.cnf ) , I do not see any access log enabled or mentioned in it, How else can i get these details.

Please assist !!

Thank you,

Comments

  • gmousegmouse Mod Squad Inactive User Role Beginner
    You can log every query. That will only log those connections that actually executed at least one query.

    Alternatively, use the Per-Client Performance Counters in Percona server. See http://www.percona.com/doc/percona-server/5.5/diagnostics/user_stats.html
  • systemalisystemali Advisor Current User Role Beginner
    Hello "gmouse"

    Basically, The issue is, My client thinks some one is snooping into the DB server and stealing away data and he needs to know what are the ips from where the DB server has been accessed so that necessary action can be taken.

    But since i don't see any access log on the server i am a bit confused as to where do i get the data from :(

    Is there something in this regards that you can assist with ?

    Thank you for your time.
  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    Hi,

    There is no MySQL "access log". As gmouse said if you want to get IP information you will need to enable general or slow query log or use Percona's userstat feature. He has posted the link.

    Regards.
  • systemalisystemali Advisor Current User Role Beginner
    Thank you for your revert "miguelangelnieto", But since neither general nor slow query has been enabled to avoid disk space issues ...

    I appreciate your response to my query and enlightening me on the same.

    Thank you
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.