用户管理

终端登录mysqlmysql -u"用户名" -p"密码" "数据库(可选)";
root 用户创建用户create "用户名"&"localhost" identified by "123";
单前用户修改密码set password =password("*******");
删除用户 drop user "用户名"@"localhost"或者delete from user where user="用户名"

mysql -uroot -p
mysql -h 127.0.0.1 -p8080 -uroot -p123 homework

set password = password("1234");

use mysql;
select user from user;

delete from user where user="要删除的用户";
-- 或者
drop user "要删除的用户" @"localhost" ;