MYSQL closes the remote connection and the program cannot be accessed. What is the reason?

if you want to close remote 3306 access due to security problems, add
skip-networking
shared_memory=ON

to the my.ini file.

at this time, you can access mysql
with navicat, but not with the program.
Baidu has no root cause for a long time. I don"t know if the community has a solution.
Thank you

there is currently no LAN environment test. Also ask an idiot question, if I turn off remote access, can the LAN still be accessed?
I don"t think so, but I don"t have the concept to convince myself. Not a server, but a network environment, this really does not know.
Thank you

Oct.09,2021

disables 3306 in the inbound rules of the firewall.


add skip-networking to make sure you can access it with navicat? With this parameter added, I can't access it with navicat.
several other vm virtual machines with the same network segment cannot be accessed by testing.

Menu