[solved] (noob?) MySQL connection over LAN

Message

Arla · Post by **Arla** » Thu Jun 14, 2007 12:24 pm

I've got one machine running a MySQL daemon, and I try to connect to that one with another machine.
mysql -u user -h machine1 -p gives "ERROR 2003 (HY000): Can't connect to MySQL server on 'machine1' (111)" but I can ping machine1, no problem.

I'm sure there is some very easy part of configuration I have just missed...

smadasam · Post by **smadasam** » Thu Jun 14, 2007 2:30 pm

Do you have some kind of firewall between you and that machine?

Arla · Post by **Arla** » Thu Jun 14, 2007 2:47 pm

Yes, the machines are on a WLAN with a firewall-provided router.

smadasam · Post by **smadasam** » Thu Jun 14, 2007 3:37 pm

If they are on the same network that has a firewall to the rest of the world, that is ok. I was just wondering if the machine you are trying to connect to is running IPtables or something.

Post by Hu » Fri Jun 15, 2007 2:24 am

Is the target machine listening for MySQL connections over TCP? What is the output of netstat -ntl on the machine running the MySQL daemon?

Arla · Post by **Arla** » Sun Jun 17, 2007 1:49 pm

Code: Select all

# netstat -ntl | grep :3306
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN

Because MySQL uses port 3306. This is it, isn't it? I have to change the listen ip in mysql to 0.0.0.0?
How? Let's see who is the fastest of you and my googling skills

Edit: Change the bind-address in /etc/mysql/my.cnf

godish · Post by **godish** » Sun Jun 17, 2007 2:03 pm

Code: Select all

# security:
# using "localhost" in connects uses sockets by default
# skip-networking
#bind-address                           = 127.0.0.1

Comment out that line in your /etc/mysql/my.cnf

(no google)

Arla · Post by **Arla** » Sun Jun 17, 2007 2:05 pm

"Last edited by Arla on Sun Jun 17, 2007 3:03 pm"
"Posted: Sun Jun 17, 2007 3:03 pm"

Wow. Anyways, thanks.

godish · Post by **godish** » Sun Jun 17, 2007 2:06 pm

lol