How to connect to MySQL server over LAN?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ljCharlie
Forum Contributor
Posts: 289
Joined: Wed May 19, 2004 8:23 am

How to connect to MySQL server over LAN?

Post 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.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply