Ask the Expert

Making MySQL accessible in a network

I would just like to ask how I can make my MySQL server accessible in a network and what particular technology and steps are necessary to configure them? I will use VB as my programming enviroment.

    Requires Free Membership to View

To make MySQL usable in a network environment you simply perform a standard install. MySQL is enabled for TCP/IP networking by default, so no additional steps would be required. You will of course want to make sure that any firewall between the machine hosting MySQL and the other machines in the network allows traffic on port 3306.

If you are using VB6, you will want to install MySQL Connector/ODBC for ODBC connectivity to VB6. If you are using VB.NET, take a look at Connector/NET, a managed .NET provider written completely in C#.

This was first published in December 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: