Connect to remote MySQL database using SQLyog instead of PHPMyAdmin through cpanel | MySQL GUI Tools

Last updated on August 29th, 2020 at 10:01 am

Hello everyone. Today we are going to go through a mysql tutorial on remote database administration. We all know that we can manage mysql database using PHPMyAdmin through cPanel in our web host panel. But sometimes we may not have access to cPanel, but FTP and MySQL login details. So how do you connect at that time without login to cPanel?

That is not  very difficult. To do this on our windows operating system while I am using Windows 8.1, one of the mysql gui tools, called sqlyog. You go to sqlyog download page to download sqlyog, you may need to buy it. I have also tried a free mysql gui tools, but among al those mysql gui tools, sqlyog seemed to me very good and I am using this for long on a lot of projects.

Bored of reading text? Watch the tutorial in video !!!

Step 1: Upload SQLyogTunnel.php.

First find the file C:Program FilesSQLyogSQLyogTunnel.php and upload it to the root or some folder where you can access it using an url. For example if I upload it at the root of http://tanmayszone.com, then the url to this file will be like http://tanmayszone.com/SQLyogTunnel.php. However keep a not of this URL, you will need.

Step 2: Work in SQLyog

Open or Run SQLyog mysql gui tools. The following should appear.

If this is not appearing then go to File > New Connection or press Ctrl+M

If you have other saved connection settings then click “New…” button at top and give this a name.

Now write your MySQL Host Address, MySQL Username and MySQL Password in the corresponding fields on the form under the MySQL Tab

Now go to the HTTP tab and a form like following should appear.

Here, check the “Use HTTP Tunneling” checkbox and you will find the “URL” textfield will be enabled which was disabled earlier.

In this URL textfield write the URL to SQLyogTunnel.php that you obtained in Step 1.

That’s it. Click on “Connect” button to get connected.

Optionally save this connection record so that you don’t have to do this in the next time by using the “Save” button at top.