how to connect remote MySQL connection in cpanel server?
Silicon House provides fully managed linux dedicated server with the cheapest cost. There may be times when you have to connect to the database from outside your work network and if that’s the case, you need to connect to your database using third party software that does not run on the server (i.e. a MySQL client on your desktop) or also called as remote MySQL. First you have to allow the connection from within cPanel for the IP address you are connecting from. Allowing remote MySQL connections is often done to enable a program on your personal computer to access a database on the server.When remote host access is enabled, you can use remote client applications to connect to your databases directly.
Adding an IP address to allow a remote MySQL connection
1.Log into cPanel
2.Click the Remote MySQL button in the Databases section.
3.Enter the remote IP address in the Add Access Host section
Note : If you are connecting to a database from your current connection, then you get your IP address by clicking getmyip.co.in
IP address can be IPv4 address, or an IPv6 address
you may use the percentage sign character (%) as a wildcard. For example, to allow access from all IP addresses that begin with 10.0.0, enter 10.0.0.%.
4.Enter a description for the remote host in the Comment text box
Note : This is optional
5.Click the Add Host button
6.You will then see a message stating the host IP address was added to the access list
Note that if you want to add many ip address to access the database you can add here by using the above procedure.
Delete an access host
1.Log into cPanel
2.Click the Remote MySQL button in the Databases section.
3.Click Delete next to the host’s name or IP address. A confirmation message will appear.
4.Click Remove Access Host. A message of success will appear.