Remote MySQL connection

[robin]

I'm trying to connect to the MySQL server from a remote machine. I have a winbox dev machine where i run heidisql to easily check and change tables.

I can connect with the cron user and default password. If i try to connect as root with the default password however, i cannot. If i connect on the box locally, using the console MySQL client, i can login as root...

Probably i'm just forgetting something somewhere, but just have no idea what...

Anybody any idea?

[rcphq]

im actually suffering the same problem,
i

Code: Select all

 grant all privileges on *.* to 'user'@'%' identified by 'password';

and that didnt let me in from outside,
is there any setting blocking this?
(i did a

Code: Select all

flush privileges

too, and that didnt help)

[mflorell]

What is the exact rejection message you are getting?

[rcphq]

it simple isnt connecting from outside
(local works)

from windows mysql query browser "could not connect to specified instance" mysql error #2003 cant connect to mysql server on 'ip' (10065)

Edit: i found the solution: http://www.eflo.net/VICIDIALforum/viewtopic.php?t=5912&highlight=mysql+connection apparently VicidialNow comes with iptables configured to block incoming mysql connections from outside. my bad for missing it.