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

Navicat java sql mysql

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.

Previous: UglifyJs reported an error when iview admin project npm run build was packaged

Next: How can a picture be tiled if it is introduced through the SVG sub-tag Image?

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e43794-26f75.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e43794-26f75.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?