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!

Remote Database Access Hosts via terminal possible?

Discussion in 'Database Discussion' started by gazibosension, Jun 30, 2014.

  1. gazibosension

    gazibosension Registered

    Joined:
    Jun 30, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hi,
    i would like to know if anyone knows how to add "Remote MySQL -> Remote Database Access Hosts" via terminal if there is any cpanel script that does that which i can use outside of WHM or somewhere i can edit in order to add IP address to the list of allowed access.

    thanks.
     
    #1 gazibosension, Jun 30, 2014
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,745
    Likes Received:
    2,095
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    You will not be able to manually add the entries via the command line unless you have root access to modify the MySQL users table where these grants are stored. However, you could develop a script that utilizes our API for authorizing a host. The specific function is documented here:

    MysqlFE::authorizehost

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jul 1, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Remote Database Access
  1. OptNode Hosting

    Change Remote Database IP?

    OptNode Hosting, Jan 6, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    347
    cPanelMichael
    Jan 8, 2018
  2. behinam

    remote databases are not shown in phpmyadmin

    behinam, Nov 26, 2017, in forum: Database Discussion
    Replies:
    3
    Views:
    826
    cPanelMichael
    Dec 4, 2017
  3. Rodney Ford

    SMTP error from remote mail server after pipelined MAIL 550 5.7.1

    Rodney Ford, Apr 22, 2019 at 3:05 PM, in forum: E-mail Discussion
    Replies:
    3
    Views:
    176
    unigen
    Apr 25, 2019 at 12:24 AM
  4. ipublicis

    SOLVED Problem with App that uses UAPI and API 2 - works on localhost not on live remote server

    ipublicis, Apr 14, 2019, in forum: cPanel Developers
    Replies:
    2
    Views:
    220
    cPanelMichael
    Apr 16, 2019
  5. Ian Durey

    Remote MX, O365

    Ian Durey, Apr 1, 2019, in forum: E-mail Discussion
    Replies:
    11
    Views:
    290
    cPanelLauren
    Apr 2, 2019

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.
    Accept Learn More...
    Dismiss Notice