Results 1 to 3 of 3
  1. #1
    Junior Member
    Join Date
    Jan 2007
    Posts
    1

    Default remote mysql access

    is it possible to use navicat or yoursql with a shared hosting account

  2. #2

    Default

    I have never tried it but there have been a few posts about Navicat from other members and it seems that they were able to get it running successfully. I just did a search in the forums for Navicat and a few threads were found. Hope that helps.

    -Blender

  3. #3
    Junior Member
    Join Date
    Feb 2007
    Posts
    1

    Default

    Hello. I'm just switching over to Westhost from another provider, so forgive me if this doesn't work, but this is how I have done it in the past. This will only work if you have SSH access to your account; I'm not sure if it's available with "shared hosting".

    You will need to use an "SSH Tunnel". Basically, you create an SSH connection to the Westhost server, and this connection acts as a "tunnel", which allows software on your computer (i.e. Navicat, EMS MySQL manager, Microsoft Access, Crystal Reports) to see your MySQL database as if it were hosted on your computer. As a bonus, the SSH tunnel is encrypted, so no one can see your data as you use it.

    You will need your SSH user name and password, and your server address. The first program to try is free, and it's called "Bitvise Tunnelier":



    Install it, and in the main "login" page, enter your host (the mysql server IP or address), the port login (default 22), your username, and password.

    Then, go to the "C2S Forwarding" page. Enter the following:

    Status: Enabled
    Listen Interface: (The local address Navicat will look for; 127.0.0.1 works well)
    Listen Port: (The port Navicat will look for a MySQL on; 3307 works well)
    Destination Host: (The address of your MySQL Server)
    Destination Port: (The port your MySQL server uses for connections; usually 3306)

    Then click "login".

    It should look like this:



    Now, start your MySQL front-end, and point it to 127.0.0.1:3307 (that's "127.0.01, port 3307") Then, you'll have to enter a username and password for your database. Then you are good to go.

    Navicat has built-in SSH tunneling, but I was never able to get it to work. But you can give it a try using the settings from above as a template.

Similar Threads

  1. JDBC access to mySql
    By mfremont in forum PHP / MySQL
    Replies: 2
    Last Post: 05-02-2010, 07:38 PM
  2. JDBC access to Mysql 3.23
    By EMH_Rick_1 in forum General Discussion
    Replies: 6
    Last Post: 08-07-2007, 01:13 PM
  3. Remote access to MySQL via NetBean IDE
    By hhariri in forum PHP / MySQL
    Replies: 2
    Last Post: 12-13-2006, 02:37 PM
  4. Replies: 16
    Last Post: 05-10-2006, 07:29 PM
  5. Remote access to MySQL Database
    By alonetto in forum PHP / MySQL
    Replies: 1
    Last Post: 01-05-2005, 03:37 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •