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!

Add ANY user to MySQL

Discussion in 'Database Discussion' started by Eiler, Mar 2, 2011.

  1. Eiler

    Eiler Member PartnerNOC

    Oct 18, 2010
    Likes Received:
    Trophy Points:

    I want to add a ANY user to MySQL, which accepts incoming connections from a specific IP address.

    I have multiple cPanel servers online, and I want to make one phpmyadmin through which all hosting accounts can access their databases. To achieve this, the individual cpanel mysql servers must accept connections to any user from the ip of the server hosting the phpmyadmin.

    So - I tried WHM -> phpmyadmin, but I don't have permissions to add new users. Anyone knows how to add a ANY user that allows connections from a specific IP?

  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Oct 2, 2010
    Likes Received:
    Trophy Points:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    To clarify, you want to allow all users to access PhpMyAdmin on this one remote machine rather than adding one user on each machine who can access that IP? Since the way you've phrased it, it sounds like you want all databases to connect to this remote PhpMyAdmin connection.

    Is there a reason you don't simply have a remote MySQL machine setup with PhpMyAdmin on it and all of the servers clustered to that remote MySQL server? If you did that in WHM > Setup Remote MySQL server, then all your servers would connect to that remote MySQL server and any connections to or from it would be allowed.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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