How to connect to mySQL from my PC

Discussion in 'MySQL' started by Joobz, Feb 5, 2006.

0
  1. #1
    I downloaded a software to convert mySQL to Access and it's asking me to type the Host. The default is localhost but I know this is not correct so I have tried everything, IP address, domain, nameservers, etc but it refuses to connect.

    When I type the ip address, for example 11.22.33.44 and hit enter it says:
    "Access Denied for user: (using password: Yes)"

    CableOne is my ISP .... is there something I need to set up on my host to allow this connection?

    side note: the software defaults to port #3306
     
    Joobz, Feb 5, 2006 IP
  2. cpucandy

    cpucandy Peon

    Messages:
    489
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Is the mySQL database on your machine, or is it with setup throught your hosting account?

    From your message below, I get the feeling that your mySQL database is setup on some type of shared hosting account?

    If that is the case, you might not be able to access the database from a program running on your machine. Typically when an ID is established for database access, it is only able to access your database from localhost (This being the address that the server is running on).

    My hosting provider does use cpanel, and while I have never tried, I am able to type in additional ip address that I can allow a connection to the database to originate from.

    Going off the fact that your database is running on your hosting providers server, you may want to look into just doing a dump of the data into a delimited file format. You can then import this format into MS Access.
     
    cpucandy, Feb 6, 2006 IP
    Joobz likes this.
  3. Joobz

    Joobz Peon

    Messages:
    598
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #3
    This was the problem, in cpanel, I never went in and added my accessing IP (of my ISP) to the access permissions of the mySQL database

    Thanks for your input
     
    Joobz, Feb 6, 2006 IP
  4. dfsweb

    dfsweb Active Member

    Messages:
    1,587
    Likes Received:
    55
    Best Answers:
    0
    Trophy Points:
    88
    #4
    Most hosting companies won't allow remote access to a database due to security reasons. My hosting company doesn't allow it either. I like using SQLYog to access my MySQL database and the only way I can connect to it is by first creating a SSH tunnel. This is quite easy to do. All you need to do is download "Putty" and then enter your hosting server's IP address, username and password. Once this is done, you should be able to connect to the database (by using localhost). I think this should work. Good luck!
     
    dfsweb, Feb 7, 2006 IP
    Joobz likes this.