The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mySQL login log

Discussion in 'General Discussion' started by rodolfo, Oct 4, 2004.

  1. rodolfo

    rodolfo Member

    Joined:
    May 18, 2004
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    Hi there,

    I would appreciate your help what concerns to a remote connection to a given mysql database.

    Someone used the username and password to login to a database of my server and then changed some aspects of it.

    These kind of actions are logged by the server trough IP address? how and/or where it's logged?

    Regards,
    rodolfo
     
  2. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    they must be at the /var/log/messages ; might be... give it a try.
     
  3. rodolfo

    rodolfo Member

    Joined:
    May 18, 2004
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    It talks about FTP login sessions.

    The question is that the person made a remote and direct connection to the database. Maybe with phpmyadmin.

    Thanks any way linux-image.
     
  4. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    phpmyadmin can be taken by anyone who knows the password to your control panel. Else not even the root can access your phpmyadmin interface with his password. regarding the phpmyadmin log; since it is also accessed via the htttp; you can have a check on the apache logs.
     
  5. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    just to make it clear.. the root can access the database; but along with all others; but your database alone can be done only by you.

    i will get you the log file if there are any. hold on
     
  6. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    ok here it goes.. check it out here:

    grep domainname /usr/local/cpanel/logs/access_log | grep phpMyAdmin

    and that will get you all the guys who touched your phpMyadmin :)
     
Loading...

Share This Page