You are not logged in.
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
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
Thanks, i wasnt using mysqld: in hosts.allow, that worked, thanks again.
Offline