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.

1

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.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy