You are not logged in.

#1 2008-02-01 09:25:35

Sin.citadel
Member
Registered: 2008-01-22
Posts: 267

Mysql Connection error from other host on the network

installed mysql using pacman, i have made the necessary adjustments to allow it to listen on the network, no , when i use the command

# mysql -uroot -p

mysql connections works fine, but if i use any other client to connect to the server, it give me the error, (assuming 192.168.0.5 is the mysql server, and 192.168.0.11 is the client host)

#> mysql -h 192.168.0.5 -uroot -p
ERROR 2013(HY000): Lost Connection To MySQL Server at 'reading initial communication packet', system error: 0

also, i m running this under vmware workstation 6, there is no firewall configuration issue, either in the host or guest.

any help on how to solve this?

P.S: the guest is running 64-bit archlinux.

Last edited by Sin.citadel (2008-02-01 09:27:19)

Offline

#2 2008-02-01 11:31:50

byte
Member
From: Düsseldorf (DE)
Registered: 2006-05-01
Posts: 2,046

Re: Mysql Connection error from other host on the network

I think the Arch mysql package uses tcp_wrapper, check with 'ldd /usr/sbin/mysqld | grep libwrap'.
If it does:

# /etc/hosts.allow (on the server)

mysqld: 192.168.0.11

Also: man 5 hosts_access

Last edited by byte (2008-02-01 11:32:42)


1000

Offline

#3 2008-02-05 08:27:55

Sin.citadel
Member
Registered: 2008-01-22
Posts: 267

Re: Mysql Connection error from other host on the network

Thanks, i wasnt using mysqld: in hosts.allow, that worked, thanks again.

Offline

Board footer

Powered by FluxBB