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