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 access hosts - error

Discussion in 'General Discussion' started by vwiley1, Dec 5, 2006.

  1. vwiley1

    vwiley1 Well-Known Member

    Joined:
    Oct 4, 2003
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    When adding an Access Host through the cPanel/MySQL section... cPanel does create a user@xxx.xxx.xxx.xxx for each MySQL Username on that account.

    It is not GRANTing privilege's to any of the databases in that user's account though.

    In other words... Trying to run MySQL queries from the remote host setup as an access host does not work.. because even though that remote host is allowed to connect.. it does not have permission to connect to any Database.

    I can easily fix this by logging into the Root PHP MyAdmin, and granting permissions for that remote host.... but I didn't have to do this in the past.

    Server / Version : WHM 10.8.0 cPanel 10.9.0-R79 CentOS 4.4 i686


    If anyone has similar problems, or if anyone knows how to fix this... Please let me know. This is getting very frusturating as clients hosted by me now have to contact us to manually GRANT their access hosts permission to their databases.
     
  2. DaiTengu

    DaiTengu Member

    Joined:
    Nov 1, 2005
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    I'm running into the same problem, If you add a new host, you need to delete the user's access to the database, and then re-create the user, or as the OP said, manually run the GRANT option.
     
  3. vwiley1

    vwiley1 Well-Known Member

    Joined:
    Oct 4, 2003
    Messages:
    87
    Likes Received:
    0
    Trophy Points:
    6
    I figured out the removing the user from a database and then adding him back the other day as well..

    Still, it's not working quite like it used too. When you used to add an access host... it would automatically do the GRANTS for all the existing user/databases pairs for the new access host.
     
  4. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
  5. fenixer

    fenixer Well-Known Member

    Joined:
    Feb 23, 2007
    Messages:
    92
    Likes Received:
    0
    Trophy Points:
    6
    WHM 10.8.0 cPanel 10.9.0-R118

    and still the same error....... is this the way bugzilla fixes cpanel scripts at next releases (see bugzilla entry)????

    (the problem is there from WHM 10.8.0 cPanel 10.9.0-R79, at least)

    :(
     
  6. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Your version of cPanel is out of date. Please do not report issues until you confirm they still exist in the latest version of the branch you are using.
     
Loading...

Share This Page