Accessing a MySQL db from C

[TheMagicM]

so I have a simple piece of code that connects to my db. It works if I run it direct on the mysql server..but I want to be able to access that db w/that software on another machine on the internal network. If my server
is for example 192.168.0.7 am I supposed to connect to a specific port?

-Alex

[adolescent]

What connector are you using?  ODBC?  I've only done .Net programming using ODBC, and the native connectors but maybe I can help.

[TheMagicM]

I'm connecting directly using this:

if ( !mysql_real_connect ( &mysql , "localhost" , "username" etc etc


but I ran it on my development machine and substituted 192.168.0.7 which is the ip address to the server which I recieved a could not connect response.  But that same compiled code run on the server gets a connect message.

[adolescent]

The default port is 3306.  Are you specifying this?  (although, if I read the docs correctly, it's not required unless you want to force the connection to use named pipes).

[TheMagicM]

no..I just substitute localhost w/192.168.0.7 ...  

[TheMagicM]

ok, after some thinkin.. I think I need to go into mysqlcc and where i have the users setup.. I have @localhost... I need to add @ and that should take care of it.