On 8/6/06, Ro BGCT <[EMAIL PROTECTED]> wrote:
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do "mysql -u root -h localhost" just
fine and connect. However, when I try to connect via "mysql -u root
-h web1.server.com", I get the following message:
"ERROR 1130 (00000): Host '75.120.X.X' is not allowed to connect to
this MySQL server"
Now the server's hostname is web1.server.com and it resolves to
75.120.X.X fine so I know it's not an issue with that. Does anyone
have any clues why? I have a "web1.server.com" added in the mysq.user
table so I know that's not the problem.
If I add 75.120.X.X to the mysql.user table, I am able to connect via
"mysql -u root -h web1.server.com" just fine. But why won't it work
when web1.server.com is in the mysql.user table?
Hacking the mysql tables is not a good practice. Use the GRANT command
instead. Also, check this:
http://hackmysql.com/dns
Hope that helped.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
