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.

Remote MySQL

Discussion in 'General Discussion' started by morissette, Feb 11, 2011.

  1. morissette

    morissette Well-Known Member

    Joined:
    May 24, 2009
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Austin, TX
    cPanel Access Level:
    Root Administrator
    Where does remote MySQL hosts store the IP data? Any help appreciated
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello morissette,

    Do you mean for cPanel > Remote MySQL area for the IPs? If so, then it is in the /var/lib/mysql/mysql database in the user table there. You can either search the user table in WHM > PhpMyAdmin > mysql area, or in root SSH mysql command line:

    Code:
    mysql
    \u mysql
    select host,user from user;
    Thanks.
     
Loading...

Share This Page