MySQL Forums
Forum List  »  Security

Copy password from one user to another
Posted by: Noel Abela
Date: July 25, 2024 06:49AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Copy password from one user to another
264
July 25, 2024 06:49AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.