Changing the host of a mysql user:

<sxh bash>
UPDATE mysql.user SET host = 'new ip/localhost' WHERE user = 'luke'
</sxh>