Results 1 to 4 of 4

Thread: MySQL access from remote host problem

  1. #1
    Registered User
    Join Date
    Jan 2007
    Posts
    2

    Question MySQL access from remote host problem

    Hello,

    I have one main server and a few small shared hosting packages on various servers. My database is on the main server and I have scripts on the shared hosts which use that DB. While it was all on my main server it worked fine. But now I have some difficulties with accessing the DB from the remote hosts.

    I have:

    MySQL version 4.1.21-standard
    cPanel Build 10.9.0-STABLE 119

    The first issue is that for some odd reason when I create a user for the database I can use that user on only one remote host, although I add the IP's of all the remote hosts. It seems like only the remote host that first accessed the DB as that particular user can use that user. When I try to access the DB with the same user from a different host it will not work. When I add another user and use it instead on the 2nd remote host it works... and so one. So it's like only one remote host can use a particular user to access the DB. Is that the way it should be or there is some problem?

    OK second and more serious problem is that when I try to connect to the DB from one of the remote hosts I get this error:

    Code:
    Error opening database: Can't connect to MySQL server on 'x.x.x.x' (110)
    note: this problem occurs only on one of the remote hosts - the others work fine when each has a different user... and I have created a user for this one as well, but it will not work.

    The thing is I don't have much knowledge with mysql and I have rarely used it with remote hosts so I have pretty much NO idea what the problem could be. Everything is set correctly and DOES work on the other remote hosts that I've used it on. But for some reason this one can't connect to the DB.

    Any ideas what I can do?... also these shared hosting packs that I have don't provide SSH so I was wondering if there would be any way for me to diagnose the problem - which I also don't know how to do.

    Please help out folks!

  2. #2
    Registered Member markfrompf's Avatar
    Join Date
    Mar 2006
    Location
    Los Angeles, CA
    Posts
    179

    Default

    For the mysql connection problem, have you done this:
    cPanel > MySQL Databases > Access Hosts (bottom) > Adding that remote machine's IP?

    If it has a dynamic IP you are kind of scrwed, or you can get a free service from NO-IP.
    -----------------------------------------------------------
    | Mark A. Mutti: PhireFast Website Hosting
    | E: Mark.mutti@phirefast.com - P: (866) 350-4456 Ext. 100
    | 24/7 Support, 15 Minute Average Response Time
    | cPanel, Fantastico, Webmail & More!
    -----------------------------------------------------------

  3. #3
    Registered Member markfrompf's Avatar
    Join Date
    Mar 2006
    Location
    Los Angeles, CA
    Posts
    179

    Default

    Sorry to post 2wice in a row but I just noticed you said this happens only to one machine.

    So re-check that computer's IP (they change at random with some ISP's) and do the above. If that doesn't do it, I'd like you to tell a little more about the computers themselves and any possible firewalls installed in the MySQL server (central server.) Check that both of these computers are whitelisted in APF, etc.

    Please advise. Hope I can help.
    -----------------------------------------------------------
    | Mark A. Mutti: PhireFast Website Hosting
    | E: Mark.mutti@phirefast.com - P: (866) 350-4456 Ext. 100
    | 24/7 Support, 15 Minute Average Response Time
    | cPanel, Fantastico, Webmail & More!
    -----------------------------------------------------------

  4. #4
    Registered User
    Join Date
    Jan 2007
    Posts
    2

    Default

    Yes I have added the host's IP address and I believe it's not dynamic.

    Is there any certain way to check if it's dynamic although I'm 99% sure it's not.

Similar Threads

  1. Delete MySQL Remote Access Host
    By wswd in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 11-19-2008, 02:35 AM
  2. Remote MySQL Access Problem
    By mikelegg in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 06-11-2007, 05:20 PM
  3. MySQL database remote access (Access Host)
    By akot2 in forum Database Discussions
    Replies: 4
    Last Post: 12-21-2006, 09:45 AM
  4. mysql remote host problem
    By Radio_Head in forum cPanel & WHM Discussions
    Replies: 7
    Last Post: 12-06-2005, 07:59 AM
  5. [Problem] shared ips and mysql remote host
    By Radio_Head in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 03-26-2003, 04:36 AM
bargain