How to remotely connect to MySQL database located on our shared server

Remote MySQL connection is disabled on our shared servers due to security reasons, but you can easily setup SSH tunnel between your PC and our server using SSH-client (for example, Putty) with the MySQL port (3306) forwarding. After completing it you will have port 3306 on your local machine listening and forwarding to your remote server's localhost on port 3306. Thus you can connect to the remote server's MySQL database effectively as though it were running on your local box. 

Follow these steps:

  • Run Putty
  • Create a session in PuTTY using your server IP-address as hostname and port 21098
  • Select the Tunnels tab in the SSH section
  • Put 3306 as source port and 127.0.0.1:3306 as destination

putty1.png
  • Click on "Add" button

putty2.png
  • Return to the Session tab and click Save
  • Run your session by clicking on "Open" button

putty3.png

  • Run your MySQL software on local machine and use 127.0.0.1 as server host, port 3306 and your database user login details

 

  • 0 Users Found This Useful
Was this answer helpful?

Also Read

Do you have any server resource restrictions?

Yes, we do.  Your account should NOT use more than 10% of the shared server CPU for a period...

How long does it take to get my hosting account activated?

The period of activations varies for our hosting packages:1- Shared, reseller, business plans.The...

How to determine how many CPU resources I'm actually using?

All our shared hosting servers are equipped with Cloudlinux operating system at the moment, and...

How to uses CGI Center

CGI (an abbreviation of Common Gateway Interface) is a specification for transferring information...

What version of the software is used on your servers?

The following versions of software are used on our servers: cPanel 60.0.65 (Stable build)...