Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    151
    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,191
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    India
    cPanel Access Level:
    Root Administrator
    they must be at the /var/log/messages ; might be... give it a try.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. rodolfo

    rodolfo Member

    Joined:
    May 18, 2004
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    151
    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,191
    Likes Received:
    1
    Trophy Points:
    168
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,191
    Likes Received:
    1
    Trophy Points:
    168
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,191
    Likes Received:
    1
    Trophy Points:
    168
    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 :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice