Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: spyrule on August 27, 2007, 10:32:19 PM

Title: Allowing remote Db Access (from excel for example).
Post by: spyrule on August 27, 2007, 10:32:19 PM

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 ?

Title: Re: Allowing remote Db Access (from excel for example).
Post by: jester on August 27, 2007, 10:42:17 PM

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

jester.

Title: Re: Allowing remote Db Access (from excel for example).
Post by: spyrule on August 27, 2007, 11:01:27 PM

Thank you man,

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

 Thank you again.

 Spyrule

Title: Re: Allowing remote Db Access (from excel for example).
Post by: raem on August 28, 2007, 04:00:06 AM

Quote from: spyrule on August 27, 2007, 11:01:27 PM

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