mysql实践(二)
创建用户及授权
用户管理特殊命令:
创建用户
create user 'sam'@'127.0.0.1' identified by '123';
删除用户
drop user 'sam'@'127.0.0.1';
修改用户
rename user 'sam'@'127.0.0.1' to 'sam1'@'127.0.0.1';
修改密码
set password for 'sam'@'127.0.0.1' = Password('1234');
权限管理:
默认没有权限 usage
grant select on test.course to sam@localhost;