Question How to refuse all remote connections to mysql from command line?

[Mike23]

I allowed all remote connections to mysql in the Plesk UI settings.

Now I'm stuck in the command line (for another reason), and I would like to refuse all remote connections.

How can this be done through the command line ?

Thanks

 

[IgorG]

In file /etc/my.cnf set option bind-address to local connections only with:

bind-address = ::ffff:127.0.0.1

and restart mysql service.