why cannot access to mysql server remotely?

[alan123]

I tried to access to mysql server remotely but it fails, it shows error message "lost connection", the mysql server runs fine, on local machine, I find that I can only use "localhost" to connect db, I cannot use hostname or IP address locally to instead of "localhost", I have no clue what cause this issue, I also tried to change hostname to "%" in db user table, but it show the same error, can anyone help me to get this problem fixed? thanks a lot.

 

[sleipnir214]

Is your MySQL running on a recent version of RedHat Linux? If so, there is a glibc library that has a bug in it. That bug prevents users from connecting to MySQL except from the MySQL machine.

For more information, read here:

http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[alan123]

Mysql runs on RH8.0, right now I can connect to mysql server locally either by "localhost" or "machine's hostname"(this will resolve to 127.0.0.1), however it doesn't work if I use host's IP address (lost connection), is there somewhere I need to resolve IP addrss to hostname?
need help...

 

[sleipnir214]

Have you tried the workarounds listed in the bugzilla page?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[rzs0502]

What is the output if you run the following?

USE mysql;

SELECT host, user FROM user;

Your database could be only allowing connections for user 'root' on host 'localhost'

 

[alan123]

here is what I have in "select host, user from user"
------
mysql> select host, user from user;
+-------------+------------+
| host | user |
+-------------+------------+
| % | root |
| % | vstream |
| % | vstream1 |
| % | vstream3 |
| 199.4.120.4 | vstream1 |
| 199.4.120.4 | vstream2 |
| localhost | |
| localhost | access_log |
| localhost | root |
+-------------+------------+
11 rows in set (0.00 sec)

mysql>

-------
I created accounts for testing, but always see "lost connection" expect use "localhost", if I use IP to access locally:
#telnet 199.4.120.4 3306
Trying 199.4.120.4...
Connected to 199.4.120.4.
Escape character is '^]'.
Connection closed by foreign host.

don't know why? need help...

 

[sleipnir214]

This is almost certainly related the glibc bug that deals with DNS.

There are several workarounds here:

http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!