MySql on LAN

[mosh1]

Sorry for asking here - I cannot figure out how can I setup mysql on a local network
what do i need to do? i installed MySql on both and each one has his own localhost so how do I connect to other machine?

[mosh1]

Sorry for asking here - I cannot figure out how can I setup mysql on a local network
what do i need to do? i installed MySql on both and each one has his own localhost so how do I connect to other machine?

If I am not clear - please ask details.

[ShumingWang]

One computer named computer1 install mysql server , open TCP/IP 3306 port, for example ip set to 192.168.1.10 .
other computers login the mysql server ip 192.168.1.10 or computer name 'computer1'

Regards!
Shuming Wang

[mosh1]

One computer named computer1 install mysql server , open TCP/IP 3306 port, for example ip set to 192.168.1.10 .
other computers login the mysql server ip 192.168.1.10 or computer name 'computer1'

Regards!
Shuming Wang

Thanks! Where do I set ip of a computer? I use dynamic ip's

[mosh1]

One computer named computer1 install mysql server , open TCP/IP 3306 port, for example ip set to 192.168.1.10 .
other computers login the mysql server ip 192.168.1.10 or computer name 'computer1'

Regards!
Shuming Wang

Thanks!

It worked with computer name, but only with wire connected. Wireless doesn't work

[mosh1]

Any ideas why wireless connection doesn't work?

[Rick Lipkin]

Mosh

Don't forget that a wireless is a 'router' like any other router and is its own virtual LAN connected thru another router. Only devices that share the same LAN can see each other.

I am not a router guy and I know there is a way to tie all your 'lans' together so they can see each other .. just depends on your equipment.

Rick Lipkin

[mosh1]

Mosh

Don't forget that a wireless is a 'router' like any other router and is its own virtual LAN connected thru another router. Only devices that share the same LAN can see each other.

I am not a router guy and I know there is a way to tie all your 'lans' together so they can see each other .. just depends on your equipment.

Rick Lipkin

Computers can see each other

[Rick Lipkin]

Mosh

It is a bit more complicated .. each router is its own gateway and the IP numbers it generates are a subset of that routers gateway.

Again, I am no expert .. if you are calling your database by its (dns) name .. that name apparently is not being resolved.

You can go to a DOS prompt and at the command line type :

NSLOOKUP ( and the name of your server or database) and see if it resolves the IP address. You can also substitute the IP address for the name and see if it resolves that way.

This is really a Dns resolution issue between routers. I would have to do some more research .. or you can Google "dns resolution problems" ... hopefully that will give you some ideas.

Rick Lipkin

[Adolfo]

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

[ADutheil]

If your server is wireless you have to open the 3306 port of the wireless interface. Did you?

[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

Where do I put the fixed IP?

[mosh1]

If your server is wireless you have to open the 3306 port of the wireless interface. Did you?

No. How to do it?

[Rick Lipkin]

Mosh

You have to go into the Lan adapter settings .. each OS is a bit different. This is my Xp box .. Once you get to your Adapter properties .. click TCP\IP Properties and un-check DHCP and plug in the appropriate IP address that would have been issued from your Router.

Rick Lipkin

[mosh1]

Mosh
You have to go into the Lan adapter settings .. each OS is a bit different. This is my Xp box .. Once you get to your Adapter properties .. click TCP\IP Properties and un-check DHCP and plug in the appropriate IP address that would have been issued from your Router.

Where do I get that "appropriate IP address"?

PS
Don't see DHCH on your screen shot