error: 'Lost connection to MySQL server during query'

[Aaron Gray]

I have tried installing MySQL on RedHat 9 using instructions in
INSTALL-BINARY and am getting the following error when trying to finish
installing and testing MySQL :-

~~~~
$ ./bin/mysqladmin -u root -h yyyyyyyy.com password 'xxxxxxxx'

./bin/mysqladmin: connect to server at 'yyyyyyyy.com' failed
error: 'Lost connection to MySQL server during query'
~~~~

The previous command :-

./bin/mysqladmin -u root password 'xxxxxxxx'

worked fine.

Hope you can help,

Aaron

[Aaron Gray]

> Check your firewall settings,

Not the firewall :(

> check that mysql is actually listening on
> a network port rather than only a unix socket.

How do I do that ?

Aaron

[DR]

"Aaron Gray" <ang.usenet@gmail.com> ha scritto nel messaggio
news:45ub7rF8bakrU1@individual.net...

>> check that mysql is actually listening on
>> a network port rather than only a unix socket.

>
> How do I do that ?

netstat -an | grep "3306.*LISTEN"

.... change the port, if you're not using the default.


Regards,
Dimitre

[Aaron Gray]

> netstat -an | grep "3306.*LISTEN"

>
> ... change the port, if you're not using the default.

It returns :-

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

should that not be 127.0.0.1 ???

Aaron

[DR]

> It returns :-
>
> tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
>
> should that not be 127.0.0.1 ???

Oooh, MS ....
I *suppose* 0.0.0.0 means all network interfaces(loopback 127.0.0.1
included).


Regards,
Dimitre

[Bill Karwin]

"DR" <dr@invalid.address> wrote in message
news:43fa0e98$0$15785$14726298@news.sunsite.dk...

> Oooh, MS ....

The OP said he was running MySQL on Redhat 9 Linux.
On Linux, one might also try:

$ lsof -i :3306

Regards,
Bill K.

[DR]

> The OP said he was running MySQL on Redhat 9 Linux.

You're right,
all interfaces are represented as 0.0.0.0 on Linux too.


Regards,
Dimitre

[DR]

"Aaron Gray" <ang.usenet@gmail.com> ha scritto nel messaggio
news:45sk72F8ab91U1@individual.net...

>I have tried installing MySQL on RedHat 9 using instructions in
>INSTALL-BINARY and am getting the following error when trying to finish
>installing and testing MySQL :-
>
> ~~~~
> $ ./bin/mysqladmin -u root -h yyyyyyyy.com password 'xxxxxxxx'
>
> ./bin/mysqladmin: connect to server at 'yyyyyyyy.com' failed
> error: 'Lost connection to MySQL server during query'
> ~~~~
>
> The previous command :-
>
> ./bin/mysqladmin -u root password 'xxxxxxxx'
>
> worked fine.

Did you check the official docs?

[url]http://dev.mysql.com/doc/refman/5.0/en/gone-away.html[/url]

You can also post the output from the following command:

strace -f ./bin/mysqladmin -u root -h yyyyyyyy.com password 'xxxxxxxx'


Regards,
Dimitre

[Aaron Gray]

> strace -f ./bin/mysqladmin -u root -h yyyyyyyy.com password 'xxxxxxxx'

Are that reveals all :)

Solved it !!!

'strace' is a good cmmand.

Many thanks,

Aaron

[DR]

"Aaron Gray" <ang.usenet@gmail.com> ha scritto nel messaggio
news:45uu4oF8nctkU1@individual.net...

>> strace -f ./bin/mysqladmin -u root -h yyyyyyyy.com password 'xxxxxxxx'

>
> Are that reveals all :)
>
> Solved it !!!

DNS?


Regards,
Dimitre

[Aaron Gray]

> DNS?

Yep :)

Aaron

[Aaron Gray]

>> Solved it !!!

>
> DNS?

There was a DNS problem but now thats solved. BUT ...

Still not working, should have not said I solved it :(

~~~~~
connect(3, {sa_family=AF_INET, sin_port=htons(3306),
sin_addr=inet_addr("xx.xx.xx.xx")}, 16) = -1 EINPROGRESS (Operation now in
progress)
fcntl64(3, F_SETFL, O_RDWR) = 0
poll([{fd=3, events=POLLIN|POLLPRI, revents=POLLIN|POLLERR|POLLHUP}], 1,
43200000) = 1
brk(0) = 0x8262000
brk(0x8265000) = 0x8265000
setsockopt(3, SOL_IP, IP_TOS, [8], 4) = 0
setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
poll([{fd=3, events=POLLIN, revents=POLLIN|POLLERR|POLLHUP}], 1, 43200000) =
1
read(3, 0x8261ff0, 4) = -1 ECONNREFUSED (Connection
refused)
shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is
not connected)
close(3) = 0
write(2, "\7", 1) = 1
write(2, "./bin/mysqladmin", 16./bin/mysqladmin) = 16
write(2, ": ", 2: ) = 2
write(2, "connect to server at \'yyyyyyyy."..., 97connect to server at
yyyyyyyy.com' failed
error: 'Lost connection to MySQL server during query') = 97
write(2, "\n", 1
) = 1
exit_group(1) = ?
~~~~~

Getting 'ECONNREFUSED (Connection refused)' !

Could it be a password related thing ?

Aaron

[Aaron Gray]

> Still not working, should have not said I solved it :(

I believe it is a local loopback problem with the sites router !!!

Aaron

[DR]

"Aaron Gray" <ang.usenet@gmail.com> ha scritto nel messaggio
news:45v2elF8fe3bU1@individual.net...

>>> Solved it !!!

>>
>> DNS?

>
> There was a DNS problem but now thats solved. BUT ...
>
> Still not working, should have not said I solved it :(
>
> ~~~~~
> connect(3, {sa_family=AF_INET, sin_port=htons(3306),
> sin_addr=inet_addr("xx.xx.xx.xx")}, 16) = -1 EINPROGRESS (Operation now in
> progress)
> fcntl64(3, F_SETFL, O_RDWR) = 0
> poll([{fd=3, events=POLLIN|POLLPRI, revents=POLLIN|POLLERR|POLLHUP}], 1,
> 43200000) = 1
> brk(0) = 0x8262000
> brk(0x8265000) = 0x8265000
> setsockopt(3, SOL_IP, IP_TOS, [8], 4) = 0
> setsockopt(3, SOL_TCP, TCP_NODELAY, [1], 4) = 0
> setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
> poll([{fd=3, events=POLLIN, revents=POLLIN|POLLERR|POLLHUP}], 1, 43200000)
> =
> 1
> read(3, 0x8261ff0, 4) = -1 ECONNREFUSED (Connection
> refused)
> shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint
> is
> not connected)
> close(3) = 0
> write(2, "\7", 1) = 1
> write(2, "./bin/mysqladmin", 16./bin/mysqladmin) = 16
> write(2, ": ", 2: ) = 2
> write(2, "connect to server at \'yyyyyyyy."..., 97connect to server at
> yyyyyyyy.com' failed
> error: 'Lost connection to MySQL server during query') = 97
> write(2, "\n", 1
> ) = 1
> exit_group(1) = ?
> ~~~~~

You get ECONNREFUSED when you try to communicate with xx.xx.xx.xx on port
3306.
Do you run the command from a remote machine?


Regards,
Dimitre

[Aaron Gray]

> You get ECONNREFUSED when you try to communicate with xx.xx.xx.xx on port
> 3306.
> Do you run the command from a remote machine?

No the local machine. I will install MySQL on our other server and try it
remotely.

Many thanks for bearing with me. I have a bad cold at present so will
probably not be upto doing the second install for a few days.

Your help is well appreciated.

Aaron

[Aaron Gray]

> ~~~~

> $ ./bin/mysqladmin -u root -h yyyyyyyy.com password 'xxxxxxxx'
>
> ./bin/mysqladmin: connect to server at 'yyyyyyyy.com' failed
> error: 'Lost connection to MySQL server during query'
> ~~~~

./bin/mysqladmin -u root -h yyyyyyyy.com -p password 'xxxxxxxxx'

seems to work fine on the system where the router has local loopback.

Aaron