I've got a brand new Ubuntu 7.04 install. I installed MySQL, edited /etc/mysql/my.cnf to allow connections from my local network, but no matter what I did, I always got the following error on trying to connect to the MySQL server from a different machine:
ERROR 2013 (HY000): Lost connection to MySQL server during query
The relevant area of /etc/mysql/my.cnf:
[mysqld]
bind-address = 192.168.0.23
After hours and hours of searching, I found the following solution:
1) /etc/hosts.allow was missing in this version of Ubuntu. You can add them in this way:
sudo apt-get install tcpd
2) I added the following to my new /etc/hosts.allow file:
mysqld: 192.168.0.*
That's it! This now allows me to connect to this MySQL server from any machine on my local network. From what I understand, MySQL on Ubuntu is built with libwrap and that's why you need to edit the /etc/hosts.allow file in this case. I'm no expert, but it worked for me.
The relevant documents are here:
Mysql Docs (see the comments from March 2, 2004)
hosts.allow (useful tips for getting started)
Related:
iptables rule to allow mysql (if you're not an iptables expert)
