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.

List of mysql access hosts?

Discussion in 'General Discussion' started by payne, Jul 31, 2007.

  1. payne

    payne Well-Known Member

    Joined:
    May 31, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Seattle
    How would I get a list of all mysql access host entries including the ones set by users? Someone apparently added % and I'd like to easily find out which account/db it is.
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Look inside phpmyadmin under privileges.
     
  3. payne

    payne Well-Known Member

    Joined:
    May 31, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Seattle
    I have to click on each database that way. There are hundreds. Any way to get a total list?
     
  4. mtindor

    mtindor Well-Known Member

    Joined:
    Sep 14, 2004
    Messages:
    1,281
    Likes Received:
    37
    Trophy Points:
    48
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    How about logging into the server via SSH.

    Then type: mysql mysql (or mysql -p mysql if your root user entry is pw protected)

    Then type something like:

    select * from db where Host = '%';

    and

    select * from user where host = '%';

    Mike
     
  5. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Also, you can download many free database managers that allow excellent control. An excellent choice, although not free, is Navicat which I've used for years. Nothing seems to compare and worth every penny.
     
  6. payne

    payne Well-Known Member

    Joined:
    May 31, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Seattle
    that did it mtindor. I actually used phpmyadmin to do the query. Nice to know the access hosts are stored in the mysql db. Thanks!
     
  7. mtindor

    mtindor Well-Known Member

    Joined:
    Sep 14, 2004
    Messages:
    1,281
    Likes Received:
    37
    Trophy Points:
    48
    Location:
    inside a catfish
    cPanel Access Level:
    Root Administrator
    You are welcome !

    M
     
  8. dheerajkumar

    dheerajkumar Member

    Joined:
    Jun 3, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    One of our cilent added a access host in his cpanel => mysql databases => access host
    Now he want to delete the access host entry
    1.localhost
    2. he added a domain name (unable to delete this entry)

    Usually we will find option at side of the host to delete but we don't see for that domain cpanel
    He don't have any database created
    So, please tell us where can we find list of mysql access host and delete it?
     
Loading...

Share This Page