Cross network mysql server access

[he mings]

Hi,

I have several laptops and a standard PC connected to the same network, each machine is running its own mysql server along side a windows IIS with PHP capabilities. I would like to use the PC as the main data hub for the network. By this I mean I would like to be able to export databases created on the hub pc to the laptops without having to work on each laptop individually. This would enable me to move data between machines ready for presentations etc where the laptop will not be connected to the network or the internet.

I have been using sqlyog for a while and know that you can access multiple mysql servers at the same time and the sync data between them, however I am having real trouble accressing the mysql servers running on the networked laptops.

Does anyone know what the Mysql host address should be to accress mysql servers accross a network?

Thanks in advance

[peterlaursen]

Just use the local ip as “MySQL Host Address” 🙂

If the servers are configured to run at different ports and you have a router you can also use the global ip (from inside or outside) or a dyndns-domain and provide the respective port. Depending on the router however it could result in some (!) internet traffic.

If your servers are set up to allow access through “named pipes” I know you can use that name too, but I'm not sure if YOG supports it. And besides I know nothing about it. Search the MySQL documentation … or wait for someone else who know more about it 🙂

[Ritesh]

You basically need to provide the IP address of the machine in which MySQL is running.

As of now, SQLyog does not support connections through named-pipes.

[he mings]

Evening,

Thanks for you help but I am still unable to connect. I have all the servers plugged into the same hub which is conected to a router which in turn is conneted to the web. I have tried to use the server local ip address and am getting the error no. 2003 Can't connect to Mysql server on '***.***.*.* (10060). I have checked and double checked tha the username and password I'm using are correct, but still no joy.

Any ideas?

[peterlaursen]

“I have checked and double checked tha the username and password I'm using are correct, but still no joy.”

And how did you do that ??

And we are takking about connecting with sqlyog and not som other tool ?

Can you connect from another client?

Can you connect as “root” ? (since it's your own servers you must know the password of user “root”.

do you connect from a windos machchine otuside or inside the LAN ?

Try reading this thread too !

http://www.webyog.com/forums/index.php?act…t=ST&f=4&t=1153

You are very little informative, and its very har to help then. Provide a detailed information and some screenshots too !

[he mings]

I checked the username and password using a trial version of sqlyog loaded onto one of the laptops. I then used the connection window to connect to the localhost mysql server.

not use what you mean by can i connect from another client.

like you say i do know the passwords for the root user, it is this user i am try to log on with. I still haven't set up any additional users, because i can't get it connect properly and i didn't want to confuse matters.

I'm connecting using a windows machine inside the lan. The lan consists of one router two hubs. The machines i trying to connect (for want of a better word) are connected to the same hub.

I found this in the link you sent over;

“There is no need to configure another port than the standard 3306. You practically only do that when you are running more than one MySQL servers behind one and the same router. You have a my.ini file somewhere (older versions in windows directory, newer versions in mysql drictory). Here you can read the port that is used. But I'm 99.999 % sure that t is 3306! You should take the time to understand some of the most important settings in the my.ini file”

This is the position i am in multiple mysql servers behind the same router do i need to change the port settings? If so were do i start……..

Thanks again for all the help

mings

[peterlaursen]

If you have more mysql server on the LAN behind a router you need to let them use different ports if you want to connect from OUTSIDE the LAN. That because from outside the whole LAN is represented by the ip of the router. You change the port by editing the my.ini/my.cnf file, or you can do it from “Mysql Administrator”. From INSIDE (within the LAN / behind the router) you can use the LOCAL ip (which is different for each machine), so if that's the case there is no change ports numbers

Another client cold be “Mysql Administrator” from http://www.mysql.com. Try it – but it will probably be the same.

Can you ping the machines with mysql installed ?

It could very well be a network problem of som kind (the setup with two hubs). Couldn't you simplify the network while testing the connection. Or maybe try a switch ? And you are sure that router configuration doesn't block traffic on port 3306 ? If you presse the button “test connection” what does it say ?

[Author]

Posts