MySql on LAN

[ADutheil]

The right way is to config your router first. You should modify its DHCP server to reserve some addresses for fixed IPs. There is a great probability your router is configured to a network like 192.168.0.1/24 and the DHCP server range from 192.168.0.2 to 192.168.0.254. Change that range from 192.168.0.10 to 192.168.0.254 and set your server IP to 192.168.0.2. You´ll still have 192.168.0.3 to 192.168.0.9 in case you need other static IPs.
As for the firewall you can access it from the windows control panel of the server. You just need to add a rule to the port 3306/TCP. I never used MySQL with a windows server but with a linux server you have to edit the my.cnf file and comment out the skip-networking line to allow TCP connections from another host.

[mosh1]

The right way is to config your router first. You should modify its DHCP server to reserve some addresses for fixed IPs. There is a great probability your router is configured to a network like 192.168.0.1/24 and the DHCP server range from 192.168.0.2 to 192.168.0.254. Change that range from 192.168.0.10 to 192.168.0.254 and set your server IP to 192.168.0.2. You´ll still have 192.168.0.3 to 192.168.0.9 in case you need other static IPs.

Where do I change this range?

As for the firewall you can access it from the windows control panel of the server. You just need to add a rule to the port 3306/TCP.

Already did it before. Wire connection now works.

I never used MySQL with a windows server but with a linux server you have to edit the my.cnf file and comment out the skip-networking line to allow TCP connections from another host.

TCP connections work, problem is the wireless.

[ADutheil]

The right way is to config your router first. You should modify its DHCP server to reserve some addresses for fixed IPs. There is a great probability your router is configured to a network like 192.168.0.1/24 and the DHCP server range from 192.168.0.2 to 192.168.0.254. Change that range from 192.168.0.10 to 192.168.0.254 and set your server IP to 192.168.0.2. You´ll still have 192.168.0.3 to 192.168.0.9 in case you need other static IPs.

Where do I change this range?

Access your router with an internet browser. Check your own IP configuration to find out its address. It´s called default gateway. If your network is as described above it´s most likely to be 192.168.0.1. You´ll need a login and password that can be found in the router manual or eventualy on a sticker on the router itself. That depends on the brand. This is important to make sure your DHCP server will not give your server IP to another host in the network. But if you are sure the quantity of hosts in the network is not going to grow close to the maximum of hosts allowed by your network mask (253 in case your mask is 255.255.255.0) you can use the numbers at the end of the range your DHCP server send. Ex: if the hosts in the network get low IPs 192.168.0.2 .. .3 ... .4 etc... use .253 ..252 ...251 etc... Just check one station in the network to make sure because the DHCP server can be configured to give IPs in descending order.

As for the firewall you can access it from the windows control panel of the server. You just need to add a rule to the port 3306/TCP.

Already did it before. Wire connection now works.

So do exactly the same with the wireless interface.

I never used MySQL with a windows server but with a linux server you have to edit the my.cnf file and comment out the skip-networking line to allow TCP connections from another host.

TCP connections work, problem is the wireless.

OK. That is one eventual problem solved.

[mosh1]

Access your router with an internet browser. Check your own IP configuration to find out its address. It´s called default gateway.

Cannot find it. May be its called other name in my router? I have a DI-724U D-lynk

This is important to make sure your DHCP server will not give your server IP to another host in the network. But if you are sure the quantity of hosts in the network is not going to grow close to the maximum of hosts allowed by your network mask (253 in case your mask is 255.255.255.0) you can use the numbers at the end of the range your DHCP server send. Ex: if the hosts in the network get low IPs 192.168.0.2 .. .3 ... .4 etc... use .253 ..252 ...251 etc... Just check one station in the network to make sure because the DHCP server can be configured to give IPs in descending order.

Can you explain more? I need to make sure DCHP dont give same IP to another server?

As for the firewall you can access it from the windows control panel of the server. You just need to add a rule to the port 3306/TCP.

Already did it before. Wire connection now works.

So do exactly the same with the wireless interface.

How to do it?

[ADutheil]

Access your router with an internet browser. Check your own IP configuration to find out its address. It´s called default gateway.

Cannot find it. May be its called other name in my router? I have a DI-724U D-lynk

Just try http://192.168.0.1 with your internet browser from a wired host. If your router still has its factory settings it will ask for login: admin with no password should work.

This is important to make sure your DHCP server will not give your server IP to another host in the network. But if you are sure the quantity of hosts in the network is not going to grow close to the maximum of hosts allowed by your network mask (253 in case your mask is 255.255.255.0) you can use the numbers at the end of the range your DHCP server send. Ex: if the hosts in the network get low IPs 192.168.0.2 .. .3 ... .4 etc... use .253 ..252 ...251 etc... Just check one station in the network to make sure because the DHCP server can be configured to give IPs in descending order.

Can you explain more? I need to make sure DCHP dont give same IP to another server? [/quote]
Theoretically yes, but if you are on a small network (less than 200 hosts) just use an IP number at the end of the range.

As for the firewall you can access it from the windows control panel of the server. You just need to add a rule to the port 3306/TCP.

Already did it before. Wire connection now works.

So do exactly the same with the wireless interface.

How to do it?

First try to disable your firewall to make sure the problem is firewall related.
I´m not sure it is relevant or even it exists under a windows server but you could try to set the bind-address parameter from my.cnf to = 0.0.0.0 to make sure MySQL will anwer on any interface.

[mosh1]

Access your router with an internet browser. Check your own IP configuration to find out its address. It´s called default gateway.

Cannot find it. May be its called other name in my router? I have a DI-724U D-lynk

Just try http://192.168.0.1 with your internet browser from a wired host. If your router still has its factory settings it will ask for login: admin with no password should work.

Yes I know about it but I dont see gateway there.

[mosh1]

Mosh

Some time ago I did some test with MSSQL on a Linux BOX, DNS on, and some Xp machines...

Surprinsingly, conecting thru the server's IP, was faster than using the server NETBIOS name...(at least on first connection)
Since then (some 8 years or so) I decided to only use IP access for mysql, Didn't have any problem in years.

Why don't you try to put a FIXED IP on the server, and access Mysql that way ?

From Chile
Adolfo

Adolfo,
Can you please explain where I get this IP and where I put it?
Thanks

[Adolfo]

Mosh1

Please send me a mail to desarrollo at xdata.cl

From Chile
Adolfo

[ADutheil]

Yes I know about it but I dont see gateway there.

Forget it. If you can access your router configuration page at 192.168.0.1 this address is your gateway.

[mosh1]

Mosh1

Please send me a mail to desarrollo at xdata.cl

From Chile
Adolfo

Hello!
Still waiting for answer