How to drag mysql out of the virtual machine?

Question

linux

Hello. Help, please, to solve a problem. I rolled ubuntu, mysql onto the virtual machine, made ssh access to the working machine, installed Apache. Apache is accessible from the parent system via 192.168.56.12. But here to pull out DB it is impossible. Chopped off 192.168.56.12:3306. Did port-forwarding (ssh -fNg -L 3306:localhost:3306 [email protected]) - did not help. Tell me, how can I get mysql-server out?

Answer 1

Debate in installments.
1. on the Mysql virtual machine listens on 0.0.0.0 or on the required IP? or just 127.0.0.1 ?
2. on iptables virtual machine? what about the rules?
3. on the iptables host? what about the rules?
4. Do you want to forward exactly the port through ssh, or do you want the port to be visible outside from the host?
5. check the connection and login password.

Answer 2

What does "cut off" mean? By whom?

Answer 3

Erm, did you know that MySQL comes with skip networking in its configuration by default.
That's why you can't connect to it via IP .... Only via Unix socket ......
plus netstat -an shows all the ports on which someone is listening. Make sure 3306 is there.