Page 1 of 1

Remote MySQL connection

PostPosted: Thu Oct 02, 2008 7:35 am
by 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?

same here

PostPosted: Thu Oct 23, 2008 2:26 pm
by 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)

PostPosted: Thu Oct 23, 2008 2:36 pm
by mflorell
What is the exact rejection message you are getting?

PostPosted: Thu Oct 23, 2008 2:55 pm
by 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.