目录
1.创建用户testuser1和testuser2密码为123456
4.登陆用户名为testuser1的数据库，进行检验是否成功，我们发现可以进行增删改查
5.移除用户testuser1的表中的增删改查，并且查询他的权限
6.登陆用户testuser1的数据库,我们虽然可以查看数据库但是不能对表进行增删改查的操作
show create table student3\G
alter table students3 drop primary key;
alter table student3 drop index student3_un_1;
alter table students drop check student3_chk_1;
alter table student3 drop check student3_chk_2;
alter table students modify stu_gender char(1);
alter table students drop check student3_chk_2;
alter table student3 drop constraint student3_fo_1;
alter table student3 drop key student3_fo_1;
show create table student3\G
show variables like '%validate_password%';
set global validate_password.lenggnt=3;
set global validate_password.policy=0;
create user testuser1@'%' identified by '123456',testuser2@'%' identified by '123456';
select host,user,authentication_string from mysql.user;
show grants for testuser1;
grant select,insert,update,create,alter,drop on mydb.* to testuser@'%';
show grants for testuser1;
show databases;
use mydb;
create table test(
-> id char(1),
-> name varchar(10)
-> );
revoke create,drop,alter on mydb.* from testuser1@'%';
show grants for testuser1;
show databases;
use mydb;
show tables;
create table test2(
-> id int,
-> name char(1)
-> );
7.给testuser2赋予全部的权限
grant all privileges on *.* to testuser2@'%';
