Re: mysql remote connection fails
Posted by: steve
Date: May 23, 2005 01:42AM

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.

Options: ReplyQuote

Written By
May 21, 2005 01:25PM
Re: mysql remote connection fails
May 23, 2005 01:42AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.