Re: MySQL remote access

[Jack LUNN]

Thanks Rick

It feels like after 10 days or so I'm finally getting close.
I'm not currently worried about the front-end language because once I can access the MySQL databases on the server from DOS on another PC, I'm pretty sure I will be OK.

In order to drill this down a bit I am using the following info...

My pc is on 192.168.1.2 - this is currently dynamic.
I can ping the server ( I have setup static ip ... 200 )
ping 192.168.1.200 - all OK ( this suggests I can 'see' the server )
I have a table on the server called jaxdb.

I have used ...
GRANT ALL PRIVILEGES ON jaxdb.* TO 'jack'@'192.168.1.2' IDENTIFIED BY 'pass';
on the server successfully

I have tested this from this PC with...
mysql -u jack -h 192.168.1.2 -p
Enter password .... pass
ERROR 1042 (HY000): Can't get hostname for your address

I tried a few things including ...
mysql -h 192.168.1.2 --port 3307 -u jack -p
(I may have chosen 3307 during server installation)
Enter password .... pass
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.2' (10061)

This looks like it can't 'find' the server but the 'ping' suggests otherwise.
I will now try to modify the .ini file on the server which has been suggested elsewhere.

Thanks again for your help and please let me know whether I've made a mistake somewhere or forgotten something.

Incidentally my C# code for testing is...
"datasource=127.0.0.1;port=3306;username=root;password=mysql";
This works locally..
But these don't ..
"datasource=192.168.1.2;port=3306;username=jack;password=pass";
"datasource=192.168.1.200;port=3306;username=jack;password=pass";
(getting brain-fade again)

Cheers

Jack