MySQL Forums
Forum List  »  Newbie

Re: connecting to Mysql server running on a different machine
Posted by: Barry Galbraith
Date: May 17, 2010 11:47PM

Connection to mysql server is not such a complex issue, if you've got all your information.

You can connect to mysql on any host, from any host, as long as mysql has a user defined to allow connection from the remote host, and there is no firewall blockages in between.

You should be able to connect to mysql server machine b from .net application on machine a with the same user / password as workbench uses.
Just ensure that you use <username>, not <username@machinea>.
Mysql will add the domain to check the database of allowed users.

Just had a thought.

Do you have / need .NET connector?

http://dev.mysql.com/downloads/connector/net/

Unless you are using api to connect your application to mysql, my guess is you'll the .net connector.

Good luck,
Barry.



Edited 1 time(s). Last edit at 05/18/2010 12:49AM by Barry Galbraith.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.