vicidial.org

Hi, I've got Webmin installed and allowed all TCP and UDP traffic, I've given permissions to the database and user permissions (all). I can't ODBC in to this box. I tried telnet also, but telnet from a remote box says "no route to host". The mysql works fine when telnet from localhost. Any suggestions gratefully received.

What are contents of MySQL's my.cnf?
Is "skip-networking" commented out?
Do you have line "bind-address" and what's the value in it?

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# skip-name-resolve
# skip-host-cache
max_connections=200

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

What user do you try to login with, root? Try cron and 1234 password, unless you changed it.

A bit offtopic, but may suit you- I use iptables to restrict MySQL only to the local IP, since we have 2 NICs (local/external IP), and ssh tunnel using Putty, next is the free HeidiSQL program, which I found superior by far to any similar MySQL browsing/management software, including many paid ones. This way you have encrypted connection via ssh tunnel, secured to outside world MySQL server, plus quite handy program to manipulate the database.

I get the same problem with cron. I'll try your other tips when it's up and running remotely, and yes, most useful

I worked it out. I accepted all TCP traffic after denying it in the firewall. I should have the deny all Before the accept all. That did the trick. Obviously I can now go on to only allowing port 3306.