mysql 创建,授权,删除 用户
1、创建用户
创建一个用户名是 lefunyun 密码是 X5A4FU8I0lKM21YPYUzP 账号
CREATE USER lefuyun@localhost IDENTIFIED BY 'X5A4FU8I0lKM21YPYUzP';
2、给账号授权
给账户授予lefuyun 库的所有权限,on 后面是库名,最后是密码
grant all privileges on lefuyun.* to lefuyun@localhost identified by 'X5A4FU8I0lKM21YPYUzP';
3、删除用户 lefuyun
drop user lefuyun;