3

[xubuntu] unable to open port 3306 for MySql

view full story
linux-howto

http://ubuntuforums.org – Hey all, I've been working and researching this for about a week now and I still haven't had any luck. Basically, I have been trying to open port 3306 to allow connections to my MySql server. i've added the rule into iptables, saved and restarted that i've added the rule into my router. and I have removed "skip-networking" from the my.cnf file and added the blind address in, I'm trying to get this all to work on my LAN, but it doesn't seem to work, I've also restarted the entire server and then port scanned it from outside and inside the networkin (HowTos)

xskl's picture
Submitted by xskl on 07/18/2010 – Made popular on 07/18/2010

Stories similar to [xubuntu] unable to open port 3306 for MySql

I am having problems connecting to remote mysql server. I am running two ec2 instances, one has mysql server configured and the other is from where I need to connect to.

Things I have done...

1. I have modified /etc/my.conf to comment out skip-networking and added bind-address to point to mysql server ip. 2. I made sure port 3306 is open for listening. 3.

Shorewall enabling MySQL port 1 year 23 weeks ago

I've recently set up an ubuntu server to host my site - I need to open up port 3306 for MySQL access on my server.

I'm currently using shorewall on my server - how can open incoming connections to 3306 in shorewall?

Safe remote mysql connection 1 year 16 weeks ago

As you know, keeping the mysql port 3306 opened is unsafe - but I would like to use a good mysql administrative program instead of phpmyadmin, which requires 3306 port to be opened.

Of course I can allow only my ip address to connect to 3306 port using ipfw, but the problem is that my IP address change itself every 24 hours, so I would have to add a new rule for every IP address...

Isnt there an

I am trying to open port 3306 (for remote mysql connections) on my ubuntu 12.04 server machine but for the life of me can't get the damned thing to work!

Here is what I did:

1) list current firewall rules:

$> sudo iptables -nL -v

output:

Chain INPUT (policy ACCEPT 0 packets, 0 bytes) pkts bytes target prot opt in out source destination 225 16984 fail2ban-ssh t

I'm trying to open up the MySQL (3306) port on my EC2 instance and even though I've added the rule, it appears the port is still closed. Do I need to reboot my instance for the policy changes to take effect?

I have a VPN with public and private subnets; I am considering only public subnet for now.

The node 10.0.0.23, I can ssh into it.

I've tried to setup a proxy for mysql outbound connections using TOR's 9050 port and iptables and I failed. Any ideas how to make things working?

Schema:

Linux mysql client (or PHP function) -> 127.0.0.1:9050 (TOR socks5) -> remote_mysql_server:3306

Just want to redirect any outbound connection to port 3306 through TOR proxy.

PS. pls don't ask why :)

I am trying to open port 22 so I can do SFTP on my Windows 2008 server (A 1&1 dedicated server.)

The server uses a Packet Filter within Local Security Policy to handle this. I added a rule for port 22 but the port is not open.

Understanding SSH tunnels 34 weeks 6 days ago

I have linux (Ubuntu) server which I have root access too through ssh (port 22) only. On that server there is a MySQL database listening on port 3306. Is it possible to use putty (on my machine) and tunneling (on the linux machine) to create a tunnel from a local port on my machine, to the linux server on port 22 and then from the server to itself on port 3306 ?