Limit hostnames for user I am running MySQL optimisation wizard, mysqltuner, which gives the suggestion:


  User 'root@%' does not specify hostname restrictions.


How is this achieved? I can't readily find an answer.
root, assuming it is the SUPER user, should be very restricted.

'root'@'my.domain.com'

'root'@'11.22.33.44'


In other situations, you might want

'joe'@'192.168.%'

'sal'@'%.our-domain.com'