Copy password from one user to another

[Noel Abela]

With mysql5.5 we used to copy passwords from one user to another with the following sql

update mysql.user set password = ((select pass from (select password as pass from mysql.user where mysql.user.user='nla_jim' and mysql.user.host='localhost') as c)) where mysql.user.user ='abc_jim';

Is there a way to do this same thing on mysql8? We are using native passwords.