How can I open port 3306

Virtualmin
1

Am moving servers and I want to run my datebase from my old server untill all the dns transfers are done (zero downtime this way)

But when I try to connect to my datebase from the new server

Ive looked at the filewall setting looks about confusing to me so any help will be great

Cheers

2

First some questions: What distribution are you using on the old server? Does your hoster do any packet filtering?

To see if a local Linux firewall is active, use this command (please paste its output in [code][/code] tags): iptables -v -L

You also need to configure MySQL to listen on the ethernet interface. By default, it only listens on localhost. You can do that in the Webmin MySQL module, icon “Server Configuration”.

3

[code]iptables -v -L
Chain INPUT (policy ACCEPT 50M packets, 2181M bytes)
pkts bytes target prot opt in out source destination

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
pkts bytes target prot opt in out source destination

Chain OUTPUT (policy ACCEPT 5144K packets, 70G bytes)
pkts bytes target prot opt in out source destination [/code]
Output as follows I will now look at the mql module

Cheers

4

Okay, that means you have no local firewall active.

If your hoster does not apply a packet filter, it should be just a matter of configuring MySQL to listen on “0.0.0.0” to resolve this.

5

Cool how can I get it to listen on the ip of the other server as well

I tryed setting MySQL server listening address to any with out luck…

Cheers

6

If you edit the /etc/mysql/my.cnf file (it may be in other locations depending on your distro), look for the “bind-address” line, and make sure that’s set to “0.0.0.0”.

Then, restart MySQL, and it should be available.

There’s going to be a few other tricks to making all that work though – remember that each individual web application would likely be configured to access a local MySQL, possibly using a unix socket… you’d need to reconfigure the config file of each of those web applications to access the remote server.

Secondly, after enabling MySQL to listen for remote connections – you still have to give each individual MySQL user permission to log in from the IP of your new server.

You can do that in Edit Databases -> Remote Hosts.

-Eric

7

Secondly, after enabling MySQL to listen for remote connections – you still have to give each individual MySQL user permission to log in from the IP of your new server.

You can do that in Edit Databases -> Remote Hosts.

That was the one! Thanks guys working fine now