How to connect to MySQL server over LAN?
Moderator: General Moderators
How to connect to MySQL server over LAN?
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.
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
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
http://dev.mysql.com/doc/refman/5.0/en/ ... users.html - is somewhere to start.
Mac