MySQL asked during installation to Win7 whether I wanted TCP-IP connection -


I installed MySQL 7 years ago, and do not remember that if this happens, then I do not remember my response.

However, I did not say today, because you have to open the harbor, okay?

But I'm a resin-web. XML is what it wants to fill:

  & lt; Url & gt; Jdbc: mysql: // localhost: 3306 / '' dbname '' & lt; / Url & gt; & Lt; Users & gt; '' Username '' & lt; / User & gt; & Lt; Password & gt; '' Password '' & lt; / Password & gt; My first question is: If I port 3306 (I guess it is estimated by creating an allowed program entry in Windows 7 firewall), is it risky?  

Is not it the way to do it and still gets MySQL on the shared machine?

Thanks for any help.

No, you have to open it, especially to connect far, just try locking it down Make sure that this is only accessible from the local subnet, and make sure that your Windows machine is behind any kind of router to prevent the evil kids from the firewall or the Internet.

Lock your MySQL users For example, do not allow root @% to access without a password.

You can also configure an SSL connection in MySQL:

Comments