MySql Remote connection frustration 1

[Beeps]

I'm having problems in trying to remote connect to a database and it's driving me nuts.

Database is on server, trying to connect to it through internet using MySQL Control Center with following settings:

Name: Lucca
HostName: IP address of server
UserName: Beeps
Password: """"
Port: 3306

I've made sure that the firewall will allow entry and can successfully ping the server, but I get the following error:

Error 2003: Can't connect to MySQL server on "ip" (10060)

I know it's the weekend, but if anybody can help me, I'd really appriciate it!

Thanks in advance!

 

[dalchri]

Make certain that the username, "Beeps" has permission to connect from the hostname "%". If you can't login you probably can't verify this until you can login locally again or have a username that works but...

GRANT ALL PRIVILEGES ON *.* TO 'Beeps'

Ought to do it or more specifically...

GRANT ALL PRIVILEGES ON *.* TO 'Beeps'@'%'

You can verify by going straight to the permissions table and making certain that the host is a wildcard for the user you are trying to connect with:

SELECT * FROM mysql.user

You may also modify the host by issuing an UPDATE against the permissions tables but make sure you issue

FLUSH PRIVILEGES

afterwards.

 

[Beeps]

Thanks for replying dalchri,

I did have my user settings setup incorrectly and it turns out that the Windows firewall settings blocking port 3306.

Got it working now

Thanks