List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 5 1999 3:34pm
Subject:Re: Connecting remotly
View as plain text  
>Gday,
>I have a problem connecting to MySQL db remotely.
>On the server when I use this command it works
>./mysql  -h localhost -u root -p
>
>But when I do this
>./mysql -h 666.666.666.666 -u root -p
>it says this
>ERROR 1130: Host '666.666.666.666.xxx.xxx.xxx.xxx.xxx.xxx.com' is not
>allowed to connect to this MySQL server

Looks like a DNS problem if your system is resolving 666.666.666.666
to 666.666.666.666.xxx.xxx.xxx.xxx.xxx.xxx.com.

>I am running MySQL on slackware linux, which does not allow remote users
>connect as a root.
>What about MySQL.

MySQL allows it if you allow it in the grant tables.  MySQL access privileges
are not the same as UNIX login privileges.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
Connecting remotlyNazar5 Jul
  • Re: Connecting remotlyPaul DuBois5 Jul