Can't connect to MySQL

[tongro]

I'm quite new to Linux, and very new to Debian. I recently installed Sarge, and then MySQL, on a machine connected to my home network. I can play with MySQL on localhost no problem, and can ping the machine from my network, but I can't connect to MySQL (using default port 3306) from the network; I get the message "can't connect to MySQL server on [IP-address]". I'm sure it's not an authentication issue; the user table is set up to allow global anonymous access.

So, can anybody tell me what I need to do now?

Thanks a lot.

[petteri]

Hello. Don't really know if this has anything to do with your problem but if I log in to mysql from command line (mysql -u petteri -p) i have to have granted user rights to petteri@localhost but if I use php-application (from the same machine) the use rights have to be granted to user petteri@localhost.localdomain.

[tongro]

Thanks for that.

The message indicates it's not an authentication problem, but a port-access problem. If it was to do with authentication, the message would say something like "access denied for user ...". In any event, my user table has an entry for ''@'%' with no password, which allows anonymous access from anywhere.

I'm thinking it could be some sort of firewall issue. Is Debian configured by default to block all ports? If so, what would I need to do to open port 3306?

[PopsTX]

The easiest way to "Play" with MySql is via PHPMyAdmin... Set up your server, install PHP4 and PHPMyAdmin.

Beats the heck out of shell commands!

[tongro]

I also have application programs that want to connect ...

[gollll]

Hello,

I have exactly the same problem as tongro. On a fresh Sarge installation I can connect to mysql from localhost, but not from other machines on the lan.

This is what I see:

> mysql -h 192.168.1.20
ERROR 2003: Can't connect to MySQL server on '192.168.1.20' (111)

• mysql is up and running, local connections work fine
• mysql is in it's default configuration which should accept connection on port 3306
• Other services like ssh or apache work fine and I can acces them on the lan
• It seems like port 3306 is blocked or hidden
• I can't remember having installed a firewall. How can I check?
• I've checked other network connections on strange ports like 24684. No problem.
• I've checked the logs mysql.err, mysql.log. They are empty.

So I'm really stuck. this is not the first time I'm installing mysql, but I've never had such a problem.

Does anybody have an idea what goes wrong?

thanks

Rolf

[tongro]

I fixed my problem, with help from the folks at debianhelp.org. I had a line in my.cnf saying something like "bind-address=127.0.0.1". Deleting (or commenting) this line fixed it. You might also find a line saying "skip-networking". Delete this also.

[gollll]

Hi tongro,

Yes! That's was exactly the problem!

Everything runs fine now. Thanks a lot for your help...

Cheers

Rolf