mysql connection lost in second successive query

Question

I have installed mysql 5.5 on a windows server and want to fetch it's data remotely.

My problem is when I send two successive query, the second one got lost connection error. when I wait something around one minutes an try again the quest successfully return results.

Update 1 I connect to remote database thro command line

Update 2: When I try to increase MySQL time out I got MySQL gone away error.

Update 3

Any Idea?

Answer 1

By default, MySQL will wait for 10 seconds before responding with a connection timeout error.

You can increase the number to 120 seconds to wait for two minutes:

mysql -uroot -proot --connect-timeout 120

you also can change the variable values, you can use the SET GLOBAL query as shown below:

SET GLOBAL connect_timeout = 600;