实验1103_1

实践题1

1 使用root用户创建exam1用户，初始密码设置为123456。让该用户对所有数据库拥有SELECT、CREATE、DROP和GRANT权限

Create user ‘exam1’@’localhost’ identified by ‘123456’;

Grant select,create,drop on job.worinfo to ‘exam1’@’localhost’grant option;

2 查看exam1用户的权限

mysql> select *from tables_priv where user=’exam1’ \\G

*************************** 1. row ***************************

Host: localhost

Db: job

User: exam1

Table_name: workinfo

Grantor: root@localhost

with

Timestamp: 2015-11-03 10:35:28

Table_priv: Select,Create,Drop,Grant

Column_priv:

1 row in set (0.00 sec)

mysql> select *from columns_priv \\G

Empty set (0.00 sec)

mysql>

3 创建用exam2，该用户没有初始密码

4 用exam2登陆，将其密码设置为787878

5 用exam1登陆，为exam2设置CREATE和DROP权限

6 用root用户登陆，收回exam1和exam2的所有权限

7 创建数据库example及stu表，对exam1具有对stu表查看stu表学生姓名字段的权限

8 备份example数据库，删除example数据库，将example数据库恢复

Mysqldump –u root –p –databases job >d\\123\\back1.sql

Mysql –u root –p