Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Enabling user access across a LAN 1

Status
Not open for further replies.

ChrisRChamberlain

Programmer
Mar 23, 2000
3,392
GB
Hi all

Newbie type question - how do you install MySQL 5.0 on a workstation so that it can access the databases on a LAN server?

TIA

FAQ184-2483 - answering getting answered.​
Chris [pc2]
PDFcommandertm.net
PDFcommandertm.com
 
You just need to install the MySQL ODBC (or JDBC) connector. You can then set up an ODBC connection to the remote MySQL database, which allows your users to connect via any ODBC-aware application.
 
TonyGroves

Thanks for your reply and solution.

For any other newbies requiring to do the same,
Enable root access from remote machines
in the MySQL Server Instance Configuration wizard needs to be checked, and port 3306 needs to be added to the Exceptions list in the Win XP firewall on the MySQL server machine.

FAQ184-2483 - answering getting answered.​
Chris [pc2]
PDFcommandertm.net
PDFcommandertm.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top