BuycPanel Blog

BuycPanel Blog

Latest news and updates

Fixing MySQL Profiles

Posted by Allura on 30 08 2018.

Introduction to MySQL profiles
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.

Errors and solutions
The following list will have the errors to the left and the adjacent solutions to them:

 	Failing to connect to the remote server- Verify the settings of the DNA configuration followed by confirmation of the IP address of local server. Make sure that the MySQL server to the remote is reactive and then verify the firewall configuration of remote and local servers.
 	Incorrect SSH port- On the remote MySQL server, first confirm the SSH port and then enter the accurate SSH port for the same.
 	Invalid SSH credentials- Make sure and verify the remote MySQL server’s correct username and password.
 	When hostname is not being permitted for connecting to MySQL server- Grant access to the user…

Introduction to MySQL profiles

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.

Errors and solutions

The following list will have the errors to the left and the adjacent solutions to them:

  • Failing to connect to the remote server- Verify the settings of the DNA configuration followed by confirmation of the IP address of local server. Make sure that the MySQL server to the remote is reactive and then verify the firewall configuration of remote and local servers.
  • Incorrect SSH port- On the remote MySQL server, first confirm the SSH port and then enter the accurate SSH port for the same.
  • Invalid SSH credentials- Make sure and verify the remote MySQL server’s correct username and password.
  • When hostname is not being permitted for connecting to MySQL server- Grant access to the user by # mysql mysql -snip-mysql> CREATE USER ‘user’@’hostname’ IDENTIFIED BY ‘password’; Query OK, 0 rows affected (0.00 sec)mysql> GRANT ALL PRIVILEGES ON *.* TO ‘user’@’hostname’ WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec)
  • Lost connection with the server- Verify and confirm that the DNA configuration settings are effective and latest version.

Reverse DNS entry warnings

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 208.77.188.166

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

Remote the MySQL root password

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.