Atitit 数据控制语言与权限 DCL
目录
1.3. 修改密码update mysql.user set password 1
2.2. 添加用户并授权grant 。。。identified 2
2.3. flush privileges表示刷新权限变更 2
以root用户登录数据库,运行以下命令:
create user zhangsan identified by 'zhangsan';
运行以下命令可以删除用户:
drop user zhangsan@'%';
运行以下命令可以修改用户密码
update mysql.user set password = password('zhangsannew') where user = 'zhangsan' and host = '%';flush privileges;
grant all privileges on *.* to user1@'%'
grant all privileges on *.* to user1@'%'
命令格式:grant privilegesCode on dbName.tableName to username@host identified by "password";
grant all privileges on zhangsanDb.* to zhangsan@'%' identified by 'zhangsan';flush privileges;
mysql> grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘连接口令’;
all
mysql>grant all privileges on *.* to user1@% identified by ‘123′;
给本机用户joe分配可对所有数据库的所有表进行所有操作的权限,并设定口令为123。
MySQL用户管理:添加用户、授权、删除用户 - 陈树义 - 博客园.html