创建用户lee,口令为'1234'; 创建用户zhang,口令为'5678';创建用户sun,口令为'test'。
use stusys;
select host,user,authentication_string from mysql.user;
create user 'lee'@'localhost' identified by '1234',
'zhang'@'localhost' identified by '5678',
'sun'@'localhost' identified by 'test';
删除用户zhang。
drop user 'zhang'@'localhost';
将用户sun的名字修改为qian。
select host,user from mysql.user;
rename user 'sun'@'localhost'
to 'qian'@'localhost';