472,126 Members | 1,589 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,126 software developers and data experts.

Connecting to MySQL over a network? How?

310 100+
What I actually really want to do is to access my MySQL database running on Linux from C# programs running on Windows on the same network.

As a first step, I am simply trying to connect to my MySQL database on Linux computer A from another Linux computer B using the mysql console program from a shell window like this:

mysql -h 10.0.1.130 -u username

The IP address of the computer A is 10.0.1.130. For some reason I seem to be missing something in the configuration because I get this error:

ERROR 2003 (HY000): Can't connect to MySQL server on '10.0.1.130' (113)

Can someone point me in the right direction?

Note that I do not wish to use something like phpadmin; the point of this excersize is to be able to write Windows applications to access the database to display certain views to users.

Many thanks!
Jul 1 '08 #1
1 4737
coolsti
310 100+
Never mind, I solved the problem :)

It was the firewall on the Linux PC hosting the database that was blocking any attempts to connect.

After fixing up the firewall, I now can connect, both from my other Linux machine as well as from a C# program running on a Windows machine.

Next I need to figure out how to manipulate images ......

:)
Jul 1 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by kamilla | last post: by
4 posts views Thread by CodeImp | last post: by
3 posts views Thread by Jeremy Dillinger | last post: by
8 posts views Thread by mouac01 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.