Blog

Manage MySQL Server at Yahoo Small Business (and other shared hosting providers)

Introduction

If you are hosting your website with Yahoo Small Business Hosting, you will be forced to use a web based admin tool to manage your MySQL database. In fact, the help page on managing MySQL categorically mentions that “You will not be able to access your database using a desktop client or other tools run outside of Yahoo!”(I bet they don’t read our blog). In this article, I will show you how you can use all the cool and powerful features of SQLyog Enterprise with Yahoo Small Business Hosting. The same concepts can be applied to connect to other hosting providers like Godaddy, Network Solutions etc. which don’t provide direct access to MySQL database.

Step by Step Setup Guide

1. Login to your Yahoo web-hosting and you will land in home page of “Web Hosting Control Panel”.

2. Select “Create and Update Tab” in the Web Hosting Control panel.

Web Hosting Control Panel

3. (Optional) Click “MySQL Database” under “Other Site Building and Editing Tools” to create/alter your MySQL username/password. If you already know your MySQL user name and password, skip this step.

MySQL Database Database Administrator

4. Now you need to upload the Tunnel Page (shipped with SQLyog Enterprise) to the Yahoo Web Server.

5. Select “Easy Upload” option under “File Management Tools”.

Easy Upload

6. Type in the path to SQLyogTunnel.php (available in the SQLyog Enterprise installation folder) and click on the “Upload Files”  button.

Browse

7. Verify the uploaded file by accessing it with a browser.

8. Start SQLyog Enterprise and configure the Connection tabs as specified in the screenshots. Change the User Name and Password to your Username/Password specified in Step 4. Make sure that the MySQL Host Address is set to “mysql” and not  “localhost”.

Connect to host

Click “HTTP” tab, Check “Use HTTP Tunneling” & in the URL field, provide the URL to SQLyogTunnel.php under your domain and click on “Connect”.

Http Tunnel Tab

9. You are now connected to your hosted MySQL Server. Enjoy the power of SQLyog Enterprise!

SQLyog MySQL GUI

Download trial version of SQLyog Enterprise here.

14 thoughts on “Manage MySQL Server at Yahoo Small Business (and other shared hosting providers)

  1. @Amit

    Version history suggests that tunneling was supported in SQLyog v5.14.

    v5.14 was released in June 2006. We made a lot of changes in tunneling & functionalities since then. So, I would advise you to use the latest version.

    Regards,
    Chirag

  2. For secure tunnelling you can use HTTPS. But of course the webserver must support it.

    It is difficult for us to tell what options are available with your hosting. As you have 5.14 you can start trying with it! Only the ‘connection manager’ interface is a little bit different than with later version. You can also try with 7.12 TRIAL (they can be installed at the same time to different folders). But note than that you will need the ‘matching’ tunneler for each version (if you need them both at the same time, you can rename of course).

    But for HTTP(S) tunnelling there is only very little difference between the versions. Most important we have added an option to specify different HTTP-content-types (but only very few users will need to care about that).

    Please create a support ticket or post in our Forums should you encounter problems.

  3. I can’t get connection on my provider. I think I have checked all: MySql hostaddress to mysgl, username, password, checked for tunneling, set the url to:
    http://www.myown.dk/SQLyogTunnel.php

    I can activate the SQLyogTunnel.php by browser, but not by the connection. What else can I do wrong., or is it possible that it is impossible to connect.

  4. @Arne,

    First step is to get your authentication details right. Please contact your hosting provider for the MySQL host address. Once you are sure of it, we can help further.

    Regards,
    Chirag

  5. although i follow the discussion ok, i was using a godaddy hosting server, so the
    “mysql” for name of connection doesn’t work. You need to go to the hosting conrol panels and look at the setup options to find out the name the host uses- it isn’t hard to find. In my case it is ‘
    .db..hostedresource.com’ ( i am leaving out pertinent details for security reasons).
    Then that connection will fail anyway; i am not sure why. However the http tunnel connection will work, so everything is fine after that!!!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>