MySQL 创建用户、授权用户、撤销用户权限、更改用户密码、删除用户(实用技巧)
16lz
2022-01-01
MySQL创建用户并授权及撤销用户权限
运行环境:MySQL5.0
一、创建用户
命令:
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
例子:
CREATE USER 'dog'@'localhost' IDENTIFIED BY '123456';CREATE USER 'pig'@'192.168.1.101_' IDENDIFIED BY '123456';CREATE USER 'pig'@'%' IDENTIFIED BY '123456';CREATE USER 'pig'@'%' IDENTIFIED BY '';CREATE USER 'pig'@'%';
命令:
GRANT privileges ON databasename.tablename TO 'username'@'host';
例子:
GRANT SELECT, INSERT ON test.user TO 'pig'@'%';GRANT ALL ON .* TO 'pig'@'%';
GRANT privileges ON databasename.tablename TO 'username'@'host' WITH GRANT OPTION;
命令:
SET PASSWORD FOR 'username'@'host' = PASSWORD('newpassword');
例子:
SET PASSWORD FOR 'pig'@'%' = PASSWORD("123456");
命令:
REVOKE privilege ON databasename.tablename FROM 'username'@'host';
例子: REVOKE SELECT ON . FROM 'pig'@'%';
注意: 假如你在给用户'pig'@'%'授权的时候是这样的(或类似的):GRANT SELECT ON test.user TO 'pig'@'%', 则在使用REVOKE SELECT ON . FROM 'pig'@'%';命令并不能撤销该用户对test数据库中user表的SELECT 操作.相反,如果授权使用的是GRANT SELECT ON . TO 'pig'@'%';则
REVOKE SELECT ON test.user FROM 'pig'@'%';命令也不能撤销该用户对test数据库中user表的Select 权限.
具体信息可以用命令SHOW GRANTS FOR 'pig'@'%'; 查看.
五、删除用户
命令:
DROP USER 'username'@'host';
更多相关文章
- 保留用户自定义设置
- android用户界面之按钮(Button)教程实例汇
- Android之应用程序基础
- android用户界面-组件Widget-地图视图MapView
- android用户界面-组件Widget-画廊视图Gallery
- Android(安卓)View的介绍和使用
- Android(安卓)中文 API (27) —— SeekBar.OnSeekBarChangeListene
- android Manifest.xml选项-android:ConfigChanges
- Android入门学习笔记之人机用户界面