Page 1 of 1

How to connect to MySQL server over LAN?

Posted: Mon Nov 14, 2005 9:40 am
by ljCharlie
I have setup a mysql server on a IIS server. It runs fine under the server. I am able to connect to the mysql server on that installed server machine. However, when I tried to connect to the mysql from a different computer that is on the same network, I can't. What is the syntax on how to connect to a mysql server over the LAN? Your help is appreciated.

Posted: Mon Nov 14, 2005 9:50 am
by twigletmac
You've probably got MySQL setup to only allow localhost access. You'll need to give the user the rights to access from the other machine as well.

http://dev.mysql.com/doc/refman/5.0/en/ ... users.html - is somewhere to start.

Mac