create user aa@localhost identified by 'password';
flush privileges;
删除用户的时候:
drop user aa@localhost;(不要加引号)
flush privileges;
如果用 delete from user where user='aa';删除用户,在重新新增用户时会出现:
’mysql--operation create user failed‘
的错误。
create user aa@localhost identified by 'password';
flush privileges;
删除用户的时候:
drop user aa@localhost;(不要加引号)
flush privileges;
如果用 delete from user where user='aa';删除用户,在重新新增用户时会出现:
’mysql--operation create user failed‘
的错误。