Developers community number 1 connection string reference

Connecting to MySQL from another PC on the network

Posted 2010-04-21 14:18
by Mike Foster
in the MySQL Forum
On a simple Windows LAN the computer name of the laptop machine with the MYSQL instance is "CHARLES"

This connection string isn't working for me:
"server=CHARLES;Uid=root;database=db001; Port=3306; Persist Security Info=True;pwd=xxxxx"

Anyone have a suggestion for connecting from another PC on the network? (I'm using Visual 2005.)

Thanks!
Reply 2010-04-21 14:22
by Max Wikström
in the MySQL Forum
Can you access the machine over the network at all?

Maybe try to add "Protocol=socket;" to the connection string.

Tough to guess on this though...

Any error messages?

Good luck!
Reply 2010-04-21 14:24
by Mike Foster
in the MySQL Forum
Hi

It was the firewall who didn't let me through. It's working now.

Thanks anyway!
Copyright © 2012 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.