February 22nd, 2006, 10:06 AM
February 22nd, 2006, 10:25 AM
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:
If it works in that way it is a DNS issue.
mysql -h mydomain'sip
*** Can't find server name for address 192.168.1.1: Non-existent domain
*** Default servers are not available
"Lo importante no es saber, sino tener el teléfono del que sabe." - Les Luthiers
February 22nd, 2006, 10:26 AM
According to you this works:
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
mysql -h localhost -u guest -p
So if you want to substitute for the word localhost above you need to use:
which is the equivalent of using localhost.
mysql -h 127.0.0.1 -u guest -p
have you tried that?
February 22nd, 2006, 01:33 PM
Thanks for the help. I got it fixed just opening port 3306 in the router configuration. easy enough
comment out the bind-address entry in /etc/mysql/my.cnf. By default it limits access to the local host (127.0.0.1)