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!

Hide Remote MySql server IP address in phpmyadmin

Discussion in 'Security' started by sinai, Jan 30, 2018.

Tags:
  1. sinai

    sinai Registered

    Joined:
    Jan 29, 2018
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Dubai
    cPanel Access Level:
    Root Administrator
    Hi,
    I have connected WHM to a remote MySql server. Everything's OK. The only issue is that when I open phpmyadmin it shows the IP address of the remote mysql server (172.16.1.20:3306). What should be changed to phpmyadmin displays the host name of the remote server instead of its IP address? It is a local server and has a private IP address so I have added a host name in /etc/hosts:
    172.16.1.20 databaseserver
    and put the name in /root/.my.cnf
    [client]
    password="mypassword"
    user=root
    port=3306
    host=databaseserver
    I also changed the mysql-host in the file /usr/local/cpanel/etc/cpanel.config and set it to `databaseserver`.
    Any help is appreciated.
     
    #1 sinai, Jan 30, 2018
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,534
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I don't believe it's possible to modify the behavior of phpMyAdmin (as provided with cPanel) to hide the IP address of the actual MySQL server you are managing the database of. You can open a feature request for this at:

    Submit A Feature Request

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Jan 31, 2018
  3. sinai

    sinai Registered

    Joined:
    Jan 29, 2018
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Dubai
    cPanel Access Level:
    Root Administrator
    The strange issue is that I have done this before in one of our cPanel servers!! I attached an image, please check it out.
    I set the same configurations on the new server as the old server but the new server is showing the IP address!!!
     

    Attached Files:

    #3 sinai, Feb 7, 2018
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,534
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Do you notice any differences in the /root/.my.cnf file on the two cPanel servers (note this file includes the password, so don't post the password here on the public forums)? Is there a difference in cPanel versions?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Feb 12, 2018
  5. sinai

    sinai Registered

    Joined:
    Jan 29, 2018
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Dubai
    cPanel Access Level:
    Root Administrator
    The old server (which is displaying dbs):
    66.0 (build 34)
    [client]
    user=root
    password="XXXXXX"
    port=3306
    host=dbs
    -------------------
    The new server (which is displaying IP address):
    68.0 (build 27)
    [client]
    password=XXXXXX
    user=root
    port=3306
    host=dbs
     
    #5 sinai, Feb 13, 2018
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,534
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Could you open a support ticket using the link in my signature so we can take a closer look at the affected systems?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Feb 13, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - Hide Remote MySql
  1. Please enter the name

    Hide View Certificate Details?

    Please enter the name, Jul 13, 2019 at 5:14 PM, in forum: Security
    Replies:
    1
    Views:
    127
    cPanelLauren
    Jul 16, 2019 at 1:51 PM
  2. Fadily

    SOLVED htaccess help - hide .html

    Fadily, Jun 8, 2019, in forum: General Discussion
    Replies:
    3
    Views:
    267
    cPanelMichael
    Jun 10, 2019
  3. Mark Coates

    SOLVED Hide directories/files from clients in FTP

    Mark Coates, Mar 23, 2019, in forum: General Discussion
    Replies:
    12
    Views:
    1,088
    cPanelMichael
    Apr 17, 2019
  4. FM Kappungal

    Hide originating IP from exim headers

    FM Kappungal, Mar 7, 2019, in forum: E-mail Discussion
    Replies:
    10
    Views:
    1,152
    FM Kappungal
    Mar 24, 2019
  5. HostXNow_Chris

    How to remove or at least hide the User Manager icon?

    HostXNow_Chris, Feb 21, 2019, in forum: General Discussion
    Replies:
    2
    Views:
    185
    cPanelLauren
    Feb 22, 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