Is there a way to restrict a user's host setting so that (s)he can only connect by socket and not TCP/IP? I'd like to have this setting for the root account.
edit: As Abdul Manaf pointed out
skip-networking can be used to turn off TCP/IP connectivity altogether. But can it be done on a user account basis?