Topic: Allowing remote Db Access (from excel for example).

[spyrule]

Hello,

 I am wondering how to allow excel to connect to my mySQL Db over the local network?

 Is their a way to do this.  It always disallows me from doing so. I think I am being blocked from port 3306 on the server itself.

 Is their any way to test this, or allow that port to communicate ?

[jester]

Hi Spyrule, please search.... look here: http://wiki.contribs.org/MySQL

jester.

[spyrule]

Thank you man,

 My skills at searching seem to be completely inept! LOL!.

 Thank you again.

 Spyrule

[raem]

My skills at searching seem to be completely inept! LOL!

Here are a few indexed starting points for future reference ie look there first

http://wiki.contribs.org/Category:Howto

http://wiki.contribs.org/Category:Contrib

http://wiki.contribs.org/SME_Server:Documentation:FAQ

http://wiki.contribs.org/Main_Page

http://wiki.contribs.org/Special:Popularpages