You are not logged in.
hi, i installed mysql using pacman, i configured its root password too.
i am using archlinux in vmware, there is X installed, i m using console, and my host is vista.
when i try to connect to the mysql server using SQLyog in windows, it gives me error
Lost connection to mysql server during query
i have used mysql server on windows/ubuntu/etc , there is no problem when i set the server up in those Os's.
i have already commented the option skip-networking, so the mysql server is able to recieve tcp connections.
do i have to chage something in /etc/my.cnf
P.S: i have already set the following values in my.cnf
wait_timeout = 7200
connect_timeout = 60
max_connection = 100
max_user_connections = 90
any help would be apprecieated.
Offline
have you editted /etc/hosts.allow to permit remote connections?
Last edited by barry (2008-01-22 12:09:05)
Offline
yes i did, even after adding, the problem is the same, i also checked out my SQLyog client and it works perfectly fine on another windows host, any other suggestions?
Offline
I usually try disabling the windows firewall when things like that happen, it seems to interfere with a lot of things. Just to make sure it can see the port you could try port scanning your VM.
Offline
i m also running a ftp on the archlinux vm too, it works fine, and there is no firewall blocking the comunication between the host and the guest os, is there a problem with the archlinux mysql package.
Offline
by default mysql denies connections from (external) IP addresses, you need to change /etc/my.cnf make sure that skip-networking is removed and bind-address is set
#skip-networking
bind-address = <server-ip address>
A temporary file is just a pipe with an attitude and a will to live.
Offline
i also added the bind-address option, but mysql still wont work, i have just tried to use the mysql command from bash with with -h optio, i get this error
#> mysql -h 192.168.0.5 -uroot -p
ERROR 2013(HY000): Lost Connection To MySQL Server at 'reading initial communication packet', system error: 0
any help on how to solve this?
Offline