SiteGround website hosting is very popular lately, a lot of people are getting into this company’s hosting services by signing up for it. With SiteGround, customers are allowed to host an unlimited number of MySQL databases against each of the domain names they sign up for. However, the condition applies that anything a customer does, must fit within the allocated data storage limit implied under a plan. However, the initial shared hosting plan StartUp isn’t eligible to get unlimited number of MySQL database, but even the single database could be accessed via a remote host following the required procedures.
If you had been wondering how, you should be going through the following text.
SiteGround offers the option of accessing MySQL databases hosted on their servers to be accessed by remote hosts, or users. To enable this feature, the website owner must add the IP address or domain names of the remote users/hosts into the allowed list so that those particular MySQL databases could be accessed for free. Also, third party apps could be used for management and maintenance of MySQL databases, and the IP address of such hosts need to be added to the list of allowed hosts like the previous process. This easy and fast loading MySQL are my reasons to host with SiteGround web hosting. Since accessing MySQL databases remotely is a native feature on SiteGround hosting, there wouldn’t be any trouble.
To add domain name or IP address of the hosts into the allowed hosts list, logging into the SiteGround is necessary, and also the cPanel account if it’s been protected using username and password. After you have logged into cPanel, navigate to the group of icons marked by ‘Databases’ and click on ‘Remote MySQL’. A new screen would open with title ‘Remote Database Access Hosts’ and right next to ‘Add Access Host’ text, there should be a blank text box and a button ‘Add Host’ next to it. SiteGround customer could either add a domain name, or an IP address into this field. Upon clicking on the Add Host button, a confirmation message would appear asking the SiteGround customer whether they want to add the host into the allowed hosts lists.
For GoGeek Users
GoGeek is the highest tier shared plan, and for users of this server a MySQL connection request to semi-dedicated server’s primary IP address is blocked for security and better account management purposes. However, users are still allowed to add a remote host by adding a secondary IP address of the host. Alternately this task could be done by accessing ‘Manage’ inside My Account Section inside Customer Area. Check SiteGround Coupon codes here: http://www.selectedhosting.com/siteground-coupon-code-and-review/
You can save up to 60% with above coupon.
Users often complain regarding few issues, all related to failure of adding MySQL databases to Allowed Hosts list. Make sure that you have –
- Connected to TCP port 3306.
- Correct MySQL hostname, database name, login credentials are being used.
- The prefix of the MySQL databases should be your username with SiteGround.
- And, the process of adding allow hosts done properly.
With remote access to MySQL databases hosted on SiteGround hosting, users get a whole bunch of added functionality. If you are still finding difficulties with the process, raise a ticket with SiteGround customer care for assistance.