Enabling user access across a LAN 1

[ChrisRChamberlain]

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
PDFcommander^tm.net
PDFcommander^tm.com

 

[mbrooks]

What OS are you running?

M. Brooks

http://mbrooks.info

 

[ChrisRChamberlain]

mbrooks

Thanks for your response and apologies for not stating the obvious - Win XP SP2

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

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.

 

[ChrisRChamberlain]

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
PDFcommander^tm.net
PDFcommander^tm.com