Copy password from one user to another
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.
Subject
Views
Written By
Posted
Copy password from one user to another
264
July 25, 2024 06:49AM
127
July 26, 2024 02:02AM
113
July 26, 2024 04:55AM
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.