Hide Remote MySql server IP address in phpmyadmin

sinai

• January 30, 2018 00:09

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.

• 

  cPanelMichael

  • January 31, 2018 19:25

  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:

  0
• 

  sinai

  • February 07, 2018 07:07

  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!!!

  0
• 

  cPanelMichael

  • February 12, 2018 16:44

  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.

  0
• 

  sinai

  • February 13, 2018 06:13

  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

  0
• 

  cPanelMichael

  • February 13, 2018 16:02

  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.

  0

Please sign in to leave a comment.