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 Database Access Hosts via terminal possible?

Discussion in 'Database Discussions' 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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,171
    Likes Received:
    1,295
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #2 cPanelMichael, Jul 1, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Remote Database Access
  1. brianmp1

    Switch to Remote MySQL Database

    brianmp1, Mar 3, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    516
    cPanelMichael
    May 8, 2017
  2. Sametto Chan

    SOLVED Possible remote server/database site

    Sametto Chan, Feb 8, 2017, in forum: Database Discussions
    Replies:
    6
    Views:
    331
    Sametto Chan
    Feb 13, 2017
  3. cornishman33

    Restore Database From Remote MySQL

    cornishman33, Oct 7, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    400
    cPanelMichael
    Oct 11, 2016
  4. Clean Fuels Developer

    Remote Database Roundcube missing from Backup

    Clean Fuels Developer, Jun 19, 2016, in forum: Database Discussions
    Replies:
    2
    Views:
    554
    cPanelMichael
    Jul 10, 2016
  5. Nirjonadda

    Remote Root Account Transfer

    Nirjonadda, Aug 21, 2017 at 8:35 AM, in forum: General Discussion
    Replies:
    3
    Views:
    38
    cPanelMichael
    Aug 22, 2017 at 11:11 AM

Share This Page