Page 2 of 2 First 12
  • Jump to page:
    #16
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2006
    Posts
    51
    Rep Power
    9
    any other ideas?
  2. #17
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2004
    Location
    Mexico, DF
    Posts
    249
    Rep Power
    11
    Hi,

    It looks like to be a DNS issue, as far a i see in your results you don't have any DNS server configured.

    Have you tried to do a:
    Code:
    mysql -h mydomain'sip
    If it works in that way it is a DNS issue.

    [QUOTE=johnnybeem]
    C:\>nslookup mydomain
    *** Can't find server name for address 192.168.1.1: Non-existent domain
    *** Default servers are not available
    Server: UnKnown
    Address: 192.168.1.1

    Non-authoritative answer:
    Name: mydomain
    Address: mydomain'sip
    QUOTE]
    Regards. Germán.

    "Lo importante no es saber, sino tener el teléfono del que sabe." - Les Luthiers
  4. #18
  5. Hockey face
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    St. Catharines, Canada
    Posts
    8,144
    Rep Power
    1316
    According to you this works:
    Code:
    mysql -h localhost -u guest -p
    and you want to connect to your site? You realize that your site, if you are using your own computer is localhost right? You are using your own computer and probably going through a router if you are pointing to 192.168.1.1

    So if you want to substitute for the word localhost above you need to use:

    Code:
    mysql -h 127.0.0.1 -u guest -p
    which is the equivalent of using localhost.

    have you tried that?
  6. #19
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2006
    Posts
    51
    Rep Power
    9
    Thanks for the help. I got it fixed just opening port 3306 in the router configuration. easy enough
  8. #20
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    1
    Rep Power
    0
    comment out the bind-address entry in /etc/mysql/my.cnf. By default it limits access to the local host (127.0.0.1)
Page 2 of 2 First 12
  • Jump to page:

IMN logo majestic logo threadwatch logo seochat tools logo