Changing the host of a mysql user:

UPDATE mysql.user SET host = 'new ip/localhost' WHERE user = 'luke'