[[APi]TheMan]

I've set up MySQL, PHPMyAdmin, and Apache 2 on a server of mine, but that's not the problem; I'm having problems with accessing MySQL from machines other than the server itself. Any machine (inside or outside the LAN) can connect and use PHPMyAdmin just fine, but I cannot connect to the server via the command line on any other machine. Here's a little demo of what's going on:

From another machine on the LAN:

Code:
[theman@nacho: ~]$ telnet 192.168.1.98 3306
Trying 192.168.1.98...
telnet: connect to address 192.168.1.98: Connection refused
telnet: Unable to connect to remote host

From the server itself:

Code:
[theman@taco: ~]$ nc localhost 3306
'
4.0.22m4W:]D}j,

Anyone have a clue?

[[APi]TheMan]

Errr... fixed it. The problem was with the "bind-address" directive in /etc/mysql/my.cnf. I had figured it was a networking thing because I could only connect from the host itself, turns out all I needed was to change/comment that line and then restart mysql.

This was on a Gentoo box, by the way.

[ghporter]

Very cool. I was wondering if you'd had the needed port blocked or restricted in the router, but this is much better.

What router are you using?