Re: mysql remote connection fails

[steve]

Thanks Mani

but I'm making little progress.

First, I can only find Group Policy on my server which refers to policy for the firewall (I included a policy to allow port 3306 TCP connection though this can be tightened to only allow specific IP addresses if required).

Then, on my pc I did find the firewall settings and entered my server IP address and 3306)

I did netstat -a and used a port scanner to check that the port is listening on both my local pc and the server and it is.

Then I have granted full permissions to a test user

GRANT ALL ON *.* TO myuser@'%' IDENTIFIED BY 'password'

which is supposed to allow connection from anywhere.

And I still get the same "can't connect" message.

Also, there is no reference to skip networking in the my.cnf file for mysql (previous references to this suggest commenting out skip networking)

So I am at a loss as to what to do next.