Connecting to MySQL over a network? How?

Question posted by: coolsti (Needs Regular Fix) on July 1st, 2008 11:40 AM

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!

Not the answer you were looking for? Post your question . . .
189,798 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).