FiveTech Support Forums

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 wrote: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?

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

ShumingWang wrote: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

ShumingWang wrote: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

Any ideas why wireless connection doesn't work?

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

Rick Lipkin wrote: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

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

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

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

Adolfo wrote: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 wrote:If your server is wireless you have to open the 3306 port of the wireless interface. Did you?

Rick Lipkin wrote: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.