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?
MySql on LAN
Re: MySql on LAN
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?
If I am not clear - please ask details.
-
ShumingWang
- Posts: 465
- Joined: Sun Oct 30, 2005 6:37 am
- Location: Guangzhou(Canton),China
- Contact:
Re: MySql on LAN
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
other computers login the mysql server ip 192.168.1.10 or computer name 'computer1'
Regards!
Shuming Wang
http://www.xtech2.top
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
Mobile:(86)13802729058
Email:100200651@qq.com
QQ:100200651
Weixin: qq100200651
Re: MySql on LAN
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
Thanks! Where do I set ip of a computer? I use dynamic ip's
Re: MySql on LAN
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
Thanks!
It worked with computer name, but only with wire connected. Wireless doesn't work
-
Rick Lipkin
- Posts: 2668
- Joined: Fri Oct 07, 2005 1:50 pm
- Location: Columbia, South Carolina USA
Re: MySql on LAN
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
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
Re: MySql on LAN
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
Computers can see each other
-
Rick Lipkin
- Posts: 2668
- Joined: Fri Oct 07, 2005 1:50 pm
- Location: Columbia, South Carolina USA
Re: MySql on LAN
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
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
Re: MySql on LAN
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
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
Ji,ji,ji... buena la cosa... "all you need is code"http://www.xdata.cl - Desarrollo Inteligente
----------
Asus TUF F15, 32GB Ram, 2 * 1 TB NVME M.2, GTX 1650
Re: MySql on LAN
If your server is wireless you have to open the 3306 port of the wireless interface. Did you?
Regards,
André Dutheil
FWH 13.04 + HB 3.2 + MSVS 10
André Dutheil
FWH 13.04 + HB 3.2 + MSVS 10
Re: MySql on LAN
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
Where do I put the fixed IP?
Re: MySql on LAN
ADutheil wrote: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
- Posts: 2668
- Joined: Fri Oct 07, 2005 1:50 pm
- Location: Columbia, South Carolina USA
Re: MySql on LAN
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
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
Re: MySql on LAN
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.
Where do I get that "appropriate IP address"?
PS
Don't see DHCH on your screen shot