which query is properly for user ip?

[Francisco Pastrana]

Hi!

Just a question.

To change a user's ip, wich solution can be better or most importantly. One of the solutions is wrong?

I can't see any difference in the result.



RENAME USER user@ipaddress1 TO user@ipaddress2;

update mysql.users set Host = newIP where Host = oldIP;
flush privileges;