Related documents:
1. How to Create a Database and User for MySQL in cPanel
2. How to Allow Remote Access to a MySQL Database in cPanel
This article will give you a step by step guide on how to use HeidiSQL to remotely connect to your MySQL database. HeidiSQL is a free MySQL client that you can use to remotely connect to your database. To do so, simply follow these steps:
1) Click HERE to go to the HeidiSQL website
2) Click Installer
3) Once the installer opens, click Next >
4) Accept the agreement and click Next >
5) Click Next >
6) Click Next >
7) Select any of the additional option you want, then click Next >
8 ) Click Install
9) Click Finish
10) Once HeidiSQL opens, click New
11) Enter the server which your website is on in the Hostname/IP box
12) Enter the username which you use to log into your account into the User box
13) Enter the password which you use to log into your account into the Password box
14) Enter the name of the database which you want to access into the Databases box
15) Click Open
16) Click Yes when asked if you want to save the settings
17) You will now be able to access your database remotely!
This concludes how to use HeidiSQL to remotely connect to your MySQL database
Looking for quality web hosting? Check out Arvixe Web Hosting.
Hi,
Thanks for the detail about the SQL.
i am getting a error when trying to connect with my server ERROR 2003: Can’t connect to MySQL server (10060)
please help me . what is solution for this error.
thank you
i am getting a error when trying to connect with my server ERROR 2003: Can’t connect to MySQL server (10060)
Hi, please contact our support department support@arvixe.com so they can check your connection settings.