How do I find my firewall is blocking mysql?

I'm very new to Ubuntu. I couldn't able to connect to mysql via my programming language.

I know all my property file in my code is correct. But still I couldn't able to connect to mysql. I guess my firewall is blocking me out.

I have ufw firewall installed, how do I enable 3306 port in that?

I tried these steps but doesn't get the solution.

Thanks in advance.

2 Answers

You can use these commands to allow port 3306 through UFW

 sudo ufw allow out 3306/tcp sudo ufw allow in 3306/tcp 

And to check that the rules have been added

 sudo ufw status 

Create the file /etc/ufw/applications.d/mysql-server and include the following content.

[MySQL] title=MySQL Relational Database Server description=MySQL is a Relational Database Server commonly used in a variety of ways including to host the database of websites ports=3306/tcp 

Run command: sudo ufw allow MySQL

You should be good to go. Feel free to give it a better title and description. I just tossed something in quick like.