When I clone a user in user manger (r3914, 5.0.15), I would expect to get a user with all the privileges copied from the currently selected user. What I get is a new user with no privileges, so there seems to be no difference to creating a new user.
Is my expectation wrong?
Clone functionality in user manager
Code modification/commit
from ansgar.becker,
13 years ago,
revision 6.0.0.3917
Fix non-overtaken grants when user clicks "clone user". See http://www.heidisql.com/forum.php?t=8943
but when You clone user You can copy an encrypted password after user insert (db: mysql, table: user, column: Password) and then run flush privileges. As I think You can do that becouse I do that manually and works fine.
From that point is my suggestion to improve functionality of this function.
From that point is my suggestion to improve functionality of this function.
Oh, you're right, you can pass both a plaintext password or a hash:
To avoid specifying the plaintext password if you know its hash value (the value that PASSWORD() would return for the password), specify the hash value preceded by the keyword PASSWORD:
CREATE USER 'jeffrey'@'localhost'
IDENTIFIED BY PASSWORD '*90E462C37378CED12064BB3388827D2BA3A9B689';
Code modification/commit
from ansgar.becker,
10 years ago,
revision 8.3.0.4747
Overtake username and hashed password from old user when cloning a user. See http://www.heidisql.com/forum.php?t=8943
Please login to leave a reply, or register at first.