Troubleshooting MySQL files deals in the solutions and steps that ought to be taken when one is facing problems while making an effort to connect the MySQL server with remote.
The following list will have the errors to the left and the adjacent solutions to them:
Prior to setting up a remote MySQL server, make sure that the remote server is capable of resolving the server’s hostname to your IP address. Log in to the remote server through the SSH port in order to confirm this function and then follow the host command. That is:
root@server [~] # host 220.127.116.11
18.104.22.168. in-addr.arpa domain name pointer www.example.com
root@server [~] #Make sure you add an entry for the hostname on the remote server’s /etc/ hosts file in case you do not have a reverse DNS entry already configured for the hostname.
For changing the MySQL root password in WHM’s interface which goes by the name of MySQL root password, you can make use of the interface itself. This is done by WHM>> Home>> SQL services>> MySQL root password. If you are using the MySQL root server, the remote server is selected as the default. Therefore, make sure you choose properly between the local and the remote server’s password; whichever you are willing to change.
If the MySQL server happens to be a cPanel server, reactivate the profile of the hosting server and update the configuration file of the remote MySQL server.