1、创建root用户密码
mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123');
2、查看当前用户
3、创建普通用户
1)查看所有用户
use mysql;
select host,user,password from user;
2) 创建新用户(用户名‘newuser’,密码‘passwd’)
insert into mysql.user (Host,User,Password) Values('%','newuser',PASSWORD('passwd'));
3)修改用户名
rename user newuser to olduser;
4)删除用户
drop user olduser;
5)更改用户密码
update mysql.user set password=password('123') where user='olduser'