I have been able to install Ubuntu 12.04 with LAMP MySQL version 5.5.x

It works fine within linux, it allows me to connect from myodbc windows vista or windows 7

I have configured networking access and have been able to access from windows vista using putty and other tcp connections like mysql query browser.

I have also configured or disabled ufw firewall and apparmor.

The connection works fine until I query data from the tables.

It lets me query small amounts of data like: SELECT name FROM users limit 20 but if I do a SELECT * FROM users, it goes on a never-ending loop. This happens even on tables with very few records like 5 or even less.

The problems occur with windows because I tried ssh from linux mint and it worked fine. I need to be able to work using MyODBC either 3.51 or 5.1 since my client program is made in VB6 and connects to mysql server via tcp/ip.

The server is an HP PROLIANT ML350G6 with Intel Xeon 64 bits.

I tried several ubuntu server version (12.04 64bit, 10.10 64bit, 11.04 32bit) and none has worked I even tried CentOS 6.3 and the same.

As a reference, it works fine with onother ubuntu server version 6.x on HP Proliant 150 and mysql 5.0.x that is like 7 years old and never updated.

Help Please.