mysqld + sshd + putty + windows = problem

Post by **Big-E** » 07 Jan 2009, 05:16

Okay, so basically I am trying to do the following: Tunnel a connection from WINDOWS XP using PUTTY via SSH to connect to MYSQL so I can administer my server remotely, easily and securely without giving remote access to mysqld.

I have done the following:

Bind mysqld to all of the following: 127.0.0.1, localhost and my IP address (don't want remote access anyway)

Enabled skip-networking

Checked both ports on remote and client systems to check if 3306 is open, and ports are forwarded correctly - they are.

Check user permissions locally, they are accurate.

At ends here, help?

Post by **bad_brain** » 07 Jan 2009, 05:22

when enabling "skip-networking" mysql only allows connections from localhost, the port is shown as open on a scan but no external connections are accepted...comment it out...

Post by **Big-E** » 07 Jan 2009, 05:35

God dammit, teach me to stay up for hours upon hours. I left WAY down in the bottom of the my.cnf file bind-address: *myipaddress ....

ALL IS WELL.

Thanks.