MySQL - Query Hanging

[jorgearr]

thread436-1672679

All my queries are hanging when requested from Windows.

SELECT * FROM user; or any other simple or complex query on tables with 0 or more records.

FYI: SELECT user FROM user LIMIT 5; Works OK but SELECT * FROM user; fails. Also any LIMIT higher than 80 will fail on another query.

The issue may be related to newer hardware or mysql versions since it works fine on MySQL 5.0.24a running on an old server machine with Ubuntu Server 6.10 32 bits.

My problem is with another client who has a brand new HP ProLiant ML350 G6.
I have tried several OSs (Ubuntu 12.04, 10.10, CentOS 6.3) in 32 and 64 versions.
All bring by default MySQL 5.1.45, 5.1.61 or higher I even tried 5.5.22 - 24. The operating system works fine except MySQL when queried remotely from windows.

The query works fine when I try it directly withing linux as localhost or even if I ssh from another linux remotely.

User privileges have been granted and the remote connection works fine but not the querying which fails when I use tcp from windows vista or 7. All programs putty, query-browser, myodbc, etc. make the connection correctly but the query hangs and requires a forced program close.

I wonder if it is mysql configuration or windows configuration somehow required.

Please help.

 

[DonQuichote]

I assume that you have one database server and different clients that connect to it. If that is not the case, and different machines have their own local databases, it might be the name of the table ("user"), which is also a keyword. But in that case, the SQL mode setting is different on the various databases.

For one central database, I can only think of a few problems that might cause this.

Network problems may be the cause. That is easily tested with putty.

Or filesystem problems. But if everything runs fine when the query is fired on the server itself, that would seem unlikely. It could off course be a combination of both network and filesystem problems.


+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)