Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: juncool on November 18, 2005, 12:20:01 PM

Title: Remote Connection to MySQL in SME Server
Post by: juncool on November 18, 2005, 12:20:01 PM

hello guys, i have a visual basic application that i want to connect to mysql database stored in sme server, all of my mysql parameters are correct but i still got a connection error. i logged in a windows machine using the account created in sme server and already have same workgroup with sme, is there a port or something that i need to configure in sme to allow my application to connect successfully? i need your ideas about this problem.

thanks,

- juncool  8-)

Title: Remote Connection to MySQL in SME Server
Post by: dmac on November 18, 2005, 02:58:01 PM

What type of connection error are you getting?

Check out the MYsql web site documents,
http://dev.mysql.com/doc/refman/4.1/en/common-errors.html

The most common error is the IP blocking or the port 3306 not being enabled.

Darin

Title: Remote Connection to MySQL in SME Server
Post by: boss_hog on November 18, 2005, 03:26:54 PM

hey juncool,
Does this thread here help?

http://forums.contribs.org/index.php?topic=27289.msg112345#msg112345

Good luck
Joe

Title: Remote Connection to MySQL in SME Server
Post by: juncool on November 19, 2005, 06:08:22 AM

i have now successfully connected my application! 5 globes from me  :pint:  by the way, what would be the implication to sme server 6.01-01 if i will upgrade mysql 3.23.56 to mysql server 4.1 or 5.0? i just want to take advantage of the latest mysql server features.

thanks again and more power.  8-)